Questions on Reporting Forum

1 answer

89 views

How do I disable the clickable datapointlabels added by reportviewer

How do I disable the clickable datapointlabel that's added and shown in the report viewer. I don't need the labels to be shown and interactive.

General Discussions

answered on 24 May 2016

3 answers

147 views

Toggle visibility in Wpf report

I am trying to add toggle visibility functionality in my telerik reports. The telerik report version which I'm using is Q3 2014.

In my report, I have two groups, and a detail section.

Group1: catalog number

Group2: date

I have read the documentation for it, and when I set, it's not working. I think I'm making some mistake but I don't know where I'm going wrong.

Can someone please provide a demo code or solution to me.

General Discussions

answered on 24 May 2016

1 answer

459 views

How to pass a DateTime parameter from javascript

Hi,

I'm trying to pass a parameter to a Telerik report that is expecting a DateTime parameter from javascript. My code is this:

$("#reportViewer")
.telerik_ReportViewer({
serviceUrl: "/api/reports/",
templateUrl: "/src/vendor/ReportViewer/templates/telerikReportViewerTemplate.html",
reportSource: {
report: "MyFullyQualified assembly name",
parameters: {
sessionId: "b57c7405-5d1d-4513-841c-4c7b2015d376",
otherId: "8e44c09d-771e-453c-83e9-1723faaed2fd",
periodEnd: "2015-06-30"
}
}
});

As you can see the periodEnd is currently represented as a string in javascript. Looking at my Chrome dev tools, it looks like it's failing because the string containing the periodEnd is not being parsed as a .Net DateTime. I've also tried passing a javascript date object i.e. new Date("2015-06-30") with the same result.

The exception message I'm getting is: "Missing or invalid parameter value. Please input valid data for all parameters."

The Telerik API response to /api/reports/clients/2334-etc is as follows. You can see that the value for periodEnd is null even though I am specifying it.

[{"name":"sessionId","type":"System.String","text":"sessionId","multivalue":false,"allowNull":false,"allowBlank":false,"isVisible":false,"autoRefresh":false,"hasChildParameters":false,"childParameters":null,"availableValues":null,"value":"b57c7405-5d1d-4513-841c-4c7b2015d376","id":"sessionId","label":"b57c7405-5d1d-4513-841c-4c7b2015d376"},

{"name":"otherId","type":"System.String","text":"otherId","multivalue":false,"allowNull":false,"allowBlank":false,"isVisible":false,"autoRefresh":false,"hasChildParameters":false,"childParameters":null,"availableValues":null,"value":"8e44c09d-771e-453c-83e9-1723faaed2fd","id":"otherId","label":"8e44c09d-771e-453c-83e9-1723faaed2fd"},

{"name":"periodEnd","type":"System.DateTime","text":"periodEnd","multivalue":false,"allowNull":false,"allowBlank":false,"isVisible":false,"autoRefresh":false,"hasChildParameters":false,"childParameters":null,"availableValues":null,"value":null,"id":"periodEnd","label":null}]

Any help is much appreciated,

Ciaran O'Neill

General Discussions

answered on 22 May 2016

1 answer

149 views

Blank Lines Being Created in Report

Hi i am having a issue where on preview of data everything loooks ok but on but on the actual report in csv their are three blank lines appearing. I have shown an example of the report here. In my screen shots below i provide my excel file the actually query window result and designer that shows no way that extra blank columns are being created.

General Discussions

answered on 20 May 2016

3 answers

262 views

Reports stop working on production server

When we deploy our application to production the reports work fine for a period of time. Then the reports stop working and we get an "Object not set to a reference" error when trying to load any report. If we redeploy then the error goes away (for a period of time).

We are using Telerik Reporting v7.1.13.612 in an MVC4 web application running on Windows Server 2008 with IIS7 (Integrated Mode). The bin folder contains the assemblies Telerik.Reporting.dll and Telerik.ReportViewer.WebForms.dll (both v7.1.13.612) and the application pool has Read rights to both files.

Exception information:
    Exception type: NullReferenceException
    Exception message: Object reference not set to an instance of an object.
   at Telerik.Reporting.Processing.DocumentParametersManager`1.CreateManagers(IReportDocument definition)
   at Telerik.Reporting.Processing.DocumentParametersManager`1..ctor(IReportDocument definition)
   at Telerik.ReportViewer.WebForms.ReportRenderOperation.ProcessReport(ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext)
   at Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride()
   at Telerik.ReportViewer.WebForms.ReportPageOperation.PerformOperationOverride()
   at Telerik.ReportViewer.WebForms.HandlerOperation.PerformOperation(HttpContext context, ICacheManager cacheManager)
   at Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

General Discussions

answered on 20 May 2016

20 answers

1.1K+ views

NullReferenceException when using ReportViewer in MVC context

I'm using the ReportViewer control in the context of an MVC app, and have it setup as per an example that was provided on these forums, just like below.

This all works just great, until I deploy the application to production. When I access the application through its deployed URL, I get a yellow screen of death (although, it works if I log on to the web server locally). On the web server, the following log entry has been produced:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 24/09/2012 17:53:02
Event time (UTC): 24/09/2012 17:53:02
Event ID: 1b93729293e4496bb55489a6a5febb04
Event sequence: 333
Event occurrence: 1
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/ROOT/JobSystem.Mvc.csproj_deploy-1-129929735681023175
Trust level: Full
Application Virtual Path: /JobSystem.Mvc.csproj_deploy
Application Path: C:\inetpub\wwwroot\JobSystem.Mvc.csproj_deploy\
Machine name: AMAZONA-NN5G6SK

Process information:
Process ID: 3876
Process name: w3wp.exe
Account name: IIS APPPOOL\DefaultAppPool

Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
at Telerik.ReportViewer.WebForms.ViewerState.get_CurrentPage() in c:\temp\reporting\@RBuild-28250\Reporting_Build\Net20\Telerik.ReportViewer.WebForms\ViewerState.cs:line 123
at Telerik.ReportViewer.WebForms.ReportPageOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, Hashtable renderingContext) in c:\temp\reporting\@RBuild-28250\Reporting_Build\Net20\Telerik.ReportViewer.WebForms\ReportPageOperation.cs:line 69
at Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride() in c:\temp\reporting\@RBuild-28250\Reporting_Build\Net20\Telerik.ReportViewer.WebForms\ReportRenderOperation.cs:line 79
at Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context) in c:\temp\reporting\@RBuild-28250\Reporting_Build\Net20\Telerik.ReportViewer.WebForms\HttpHandler.cs:line 191
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Request information:
Request URL: http://development.intertekjobsys.com/JobSystem.Mvc.csproj_deploy/Telerik.ReportViewer.axd?instanceID=52255353489a40518fb367501fb9e5b7&optype=Report&PageIndex=0&RenderID=2722cd64754447ab82f6da5f52745be7&RenderingFormat=HTMLInteractive
Request path: /JobSystem.Mvc.csproj_deploy/Telerik.ReportViewer.axd
User host address: 10.248.22.26
User: admin@intertek.com
Is authenticated: True
Authentication Type: Forms
Thread account name: IIS APPPOOL\DefaultAppPool

Thread information:
Thread ID: 10
Thread account name: IIS APPPOOL\DefaultAppPool
Is impersonating: False
Stack trace: at Telerik.ReportViewer.WebForms.ViewerState.get_CurrentPage() in c:\temp\reporting\@RBuild-28250\Reporting_Build\Net20\Telerik.ReportViewer.WebForms\ViewerState.cs:line 123
at Telerik.ReportViewer.WebForms.ReportPageOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, Hashtable renderingContext) in c:\temp\reporting\@RBuild-28250\Reporting_Build\Net20\Telerik.ReportViewer.WebForms\ReportPageOperation.cs:line 69
at Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride() in c:\temp\reporting\@RBuild-28250\Reporting_Build\Net20\Telerik.ReportViewer.WebForms\ReportRenderOperation.cs:line 79
at Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context) in c:\temp\reporting\@RBuild-28250\Reporting_Build\Net20\Telerik.ReportViewer.WebForms\HttpHandler.cs:line 191
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Any ideas at all? This is virtually the last thing that I need to get working before I can put the app into production.

<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<Guid>" %>

<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=6.1.12.820, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"

Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>

<%@ Register Assembly="Telerik.Reporting, Version=6.1.12.820, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"

Namespace="Telerik.Reporting" TagPrefix="telerik" %>

<%@ Import Namespace="System.Web.Mvc" %>

<%@ Import Namespace="JobSystem.BusinessLogic.Services" %>

<%@ Import Namespace="JobSystem.Reporting.Data.NHibernate" %>

<!DOCTYPE html>

<html>

<head runat="server">

<title>Consignment Note</title>

</head>

<body>

<form id="main" method="post" action="">

<telerik:ReportViewer ID="ReportViewer1" Width="100%" Height="800px" runat="server">

</telerik:ReportViewer>

</form>

<script runat="server">

public override void VerifyRenderingInServerForm(Control control)

{

//To avoid the server form (<form runat="server">) requirement

//base.VerifyRenderingInServerForm(control);

}

protected override void OnLoad(EventArgs e)

{

base.OnLoad(e);

var dataSource = new Telerik.Reporting.ObjectDataSource();

dataSource.DataSource = typeof(NHibernateConsignmentReportDataProvider);

dataSource.DataMember = "GetConsignmentReportData";

dataSource.Parameters.Add(new Telerik.Reporting.ObjectDataSourceParameter("consignmentId", typeof(Guid), Model));

var companyDetailsService = DependencyResolver.Current.GetService<CompanyDetailsService>();

var report = new JobSystem.Reporting.ReportDefinitions.TelerikConsignmentReport();

var company = companyDetailsService.GetCompany();

System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo(company.DefaultCultureCode);

var logo = companyDetailsService.GetCompanyLogo();

var pageWidth = report.Width.Value;

report.MainLogo.Value = logo;

report.DataSource = dataSource;

var instanceReportSource = new Telerik.Reporting.InstanceReportSource();

instanceReportSource.ReportDocument = report;

ReportViewer1.ReportSource = instanceReportSource;

}

</script>

</body>

</html

>



The web.config like so:


<system.web>
<httpHandlers>
            <add type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=6.1.12.820, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" path="Telerik.ReportViewer.axd" verb="*" validate="true" />
        </httpHandlers>
<system.web>
<system.webServer>
        <validation validateIntegratedModeConfiguration="false" />
        <modules runAllManagedModulesForAllRequests="true" />
        <handlers>
            <add name="Telerik.ReportViewer.axd_*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=6.1.12.820, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" path="Telerik.ReportViewer.axd" verb="*" preCondition="integratedMode" />
        </handlers>
    </system.webServer>

General Discussions

answered on 20 May 2016

2 answers

352 views

Stop Moving on me

I am really fighting objects on my report in that when I preview them, the fields move on me.

Background: I have a 17 individual SQL queries unioned together (dont ask, it is how I have to do it do to a limitation imposed by our software not Telerik).

a. I have a table on the report that is filtered to return 5 records only. (table A)

b. beneath the table, I have a text field

c. Beneath the text field is list control with a field in it (filtered to pull just one record only) (list B)

d. to the right of Table A, I have another table that is filtered to return 10 records only (table C)

The result when previewing the report is that table A displays properly its 5 records. Table C displays properly with its 10 records. Label (point b above) displays just below table A as I designed it.

Now here is the issue. List B is below the label but it moved way down the page to start just below the end of the rows in Table C

Basically I have a bunch of tables, text fields as labels/titles all over this report and as I add items to the report, they seem to attaching themselves to other objects on the reports.

Is there a way to see what they are attached to and/or tell it to stop doing that and just go where I put the field.

I have read the document online a few times and I just can't figure this out. Any help would be great.

Report Designer (standalone)

answered on 19 May 2016

2 answers

1.4K+ views

How take Report object from TRDP File?

Hi,

I am trying to load a trdp file into memory to read what parameters a Report has to create a filter page to fill up the parameters. I also need to set the connection string and provider name dynamically. I can do it using the code on the follow link:

http://www.telerik.com/support/kb/reporting/details/changing-the-connection-string-dynamically-according-to-runtime-data

But, it works for trdx (legancy) file. Using a UriReportSource, the code bellow does not work for trdp file to take a Report object and read information on the report.

Report DeserializeReport(UriReportSource uriReportSource)

{

var settings = new System.Xml.XmlReaderSettings();

settings.IgnoreWhitespace = true;

using (var xmlReader = System.Xml.XmlReader.Create(uriReportSource.Uri, settings))

{

var xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();

var report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);

return report;

}

This code with trdx (which is a xml) works fine, but my question is about the binary trdp.

How can I convert a uriReportSource (or given a path for a trdp file how to take it) into a Telerik.Reporting.Report object?

I need to to read the structure of the report and make changes (replace connectionstirng, read expected parameters, etc..).

Thank you.

General Discussions

answered on 19 May 2016

1 answer

266 views

Customise HTML5 report viewer template export mechanism

I am using Telerik HTML5 Report Viewer Template where there are options to export PDF,CSV etc. Getting an out of memory exception while exporting to PDF because report has lot of images.

I am setting DataMember attribute to a method name to fetch report data. DataMember method is called in many instances like when report is being loaded or exported or when previewed.

Is there a mechanism by which I can get the information about what triggered the DataMember method.

For e.g. if Export to PDF is clicked how can I know that Export to PDF has triggered the DataMember method.

I also need suggestion on following stuff.

If I create a custom export to PDF button by modifying Telerik HTML5 Report Viewer Template

1. How can I hook my server side API to that button?

2. How can I pass the report parameters to that API?

General Discussions

answered on 19 May 2016

5 answers

116 views

PrintOnFirstPage property not working

Hi everyone,

i have a report with a page header. But on the first page of the report, the page header should be hidden. So i switched the property "PrintOnFirstPage" for the PageHeader Section to FALSE.

Now on the first page the PageHeader is emtpy (all child elements have been hidden), but the PageHeader itself is still visible. Why? From my point of view it should be completely hidden too. Or has anyone another point of view? ;)

Regards,
Michael

General Discussions

answered on 19 May 2016