Telerik Forums
Reporting Forum
12 answers
514 views

Hello,

I'm evaluating Telerik Reporting for an asp.net solution. I'm using the standalone Report Designer to test edit trdp files, and the html5 report viewer wrapper to display in the asp.net application (using IdentifierType="UriReportSource" and Identifier = "Dashboard.trdp").

Questions:

1. The sample trdp file I'm testing on has 9 charts/tables and they all specify the same DataSource object (a MySQL connection string is set and tested with a query). The query issued to the DB server takes around 5 seconds to return, and, given I have 9 charts linked to the DataSource, the report takes nearly 50 seconds to render. Is there a way to limit the DataSource refresh to only once and have the charts pickup from the DS?

2. In the same subject, I've tried to set a DataSet to be the datasource (ObjectDataSource) for the report, but I stumble upon the same issue in different snippets from your forums: The ReportSource data type is not DirectCast compatible with the InstanceReportSource type used by the html5 wrapper. It's been a mission to figure this out, and I wonder if I should just give up on the html5 version of the viewer and roll back to the previous version (apparently all snippet I've found appear to have no issues converting these data types).

Dim instanceReportSource As Telerik.Reporting.InstanceReportSource = DirectCast(reportViewer1.ReportSource, Telerik.Reporting.InstanceReportSource)

(and vice versa).

3. Given the data types incompatibility, is there a way for my code-behind to access the items in the report? The examples in article "Accessing Report Items Programmatically" are of no help, as apparently it uses the older version of the viewer (not html5).

Looking forward to hear from someone more experienced.
Thank you!

 

Stef
Telerik team
 answered on 28 Nov 2016
1 answer
1.1K+ views

I have been using the Report Viewer in order to create a report viewer to handle different kind of reports. I created a single report with the built-in option on Visual Studio 2015.

ReportSource rptDoc = new ReportSource();
rptDoc.IdentifierType = IdentifierType.TypeReportSource;
rptDoc.Identifier = "ReportLibrary.Sample";

 

In order to create the report. Such report does not receive any parameters, however I sill have this issue 

Unable to get report parameters.
Report 'ReportLibrary.Sample' cannot be resolved.

 

What I basically want is the following and it does not seem to have any sample or information on the whole documentation.

  • I want to use a Report and been able to set up its datasource to an objectdatasource which binds to a DataSet reading from an xml file/route.
  • Been able to set up this programmatically
  • The reportviewer must be set up on the backend side so I can enter or manipulate different reports.
  • Work on a ASP.Net web forms application.

 

Stef
Telerik team
 answered on 25 Nov 2016
1 answer
697 views
In my report I have a table that i calculating sum of values in a column. I want to be able to use the sum value in group footer as well. How can i reference the value in group footer? What is the way to store the value in variable for it to be able to be used at any other place in report. 
Katia
Telerik team
 answered on 25 Nov 2016
1 answer
170 views

Hi,
After switch to new PC and fresh instalation of Visual Studio 2015 update 3 and Telerik Reporting v. 9.1.15.731 I tried to modify DataSources in report. I have some Data Objects in the same project which uses DataObject attribute for classes as well as DataObjectMethod(DataObjectMethodType.Select) for methods. It is working on old PC without any problems. On fresh installed one when I selects "Show data components only" in data source wizard - it displays nothing. Of course project is builded up before check so assemblies are present.
Do you have any idea what can cause this problem? I spent already few hours on search with no luck so any ideas are welcome.

KAMIL
Top achievements
Rank 1
 answered on 25 Nov 2016
17 answers
320 views
Hi All,

We are using Telerik reporting control with subreports (master detailed kind of stuff) placed into design section of main report. When we export the report to PDF, we see exactly double the number of pages as displayed in the report.
Report is exported to pdf in a weired manner. First page displays main report data and next page displays only value from sub report.

The same problem is happening with the print option also.

Could you please help me out, digging this problem?

Thanks in Advance,
Rupali
doli
Top achievements
Rank 1
 answered on 25 Nov 2016
3 answers
239 views

In my ReportHeader there are a number of Fields that read from a SQL query. It works fine, as most of the fields are provided in the first row.

However there is a Field that require a condition in finding the right row. e.g.

SQL query:

CompanyName OfficeLocation  Name   Phone   EmployeeType

ABC                    Ontario            Tom      123         Contract

ABC                    Ontario            Ann       234        Full

ABC                    Ontario            May      456        Boss

 

ReportHeader:

Company Name: [=Fields.CompanyName]

Office : [=Fields.OfficeLocation]

Boss: [=Fields.Name] (Wont work, as it will display Tom and not May since Tom is the first row)

 

So how do I make it so it will display May in the Boss Field?

Pinkesh
Top achievements
Rank 1
 answered on 24 Nov 2016
4 answers
387 views

Hello,

I'm using AngularJS 1.5.0 and trying to integrate telerik reports in SPA. I found this article . However this version is using ui-router, while as Angular 1.5.0 has moved to ng-route.

Can you please share sample application with ng-route?

Apprciate quick response.

Thanks.

Stef
Telerik team
 answered on 24 Nov 2016
1 answer
107 views

Hi there,

I'm currently deploying a Telerik Report for a customer using Microsoft Dynamics GP 2010. The report works great and displays the results in Microsoft Dynamics GP successfully. Here's the thing that's weird.

When I click on the print icon of the telerik report, nothing happens. No print window pops up, nothing. When I test the same in a browser like Chrome or IE, a print window pops up as usual.

Another weird thing I'm facing is during Exporting the report (it works in the browser, but not in Microsoft Dynamics GP):
1. When I choose export as PDF, it gives the Save As window, but when I choose a destination and click on Save, the file never shows up.
2. When I choose export as Excel, the same happens as above. But when I remove the extension ".xlsx", it export it as a file (this doesn't work with PDF).
3. When I choose export as Word, it works fine.

Please note that this only happens on one client PC which is reading the report from the company's server. The report seems to work fine on the server. But when I copied the exact same files from the server to this client PC, the same issue arises.

From my experience, I have tried the fixes that may be required for Dynamics GP, but none of them helped. Therefore, I'm posting this on the Telerik forum in case I'm missing something that may be required to install on the client PC, or some DLLs that I need to add to my project.

I've already tried out the solutions provided on this link: http://www.telerik.com/forums/missing-export-formats. Telerik.Reporting.OpenXmlRendering.dll is already added in the project, and Open XML SDK 2.0 is also installed on the client PC.

Would really appreciate any help, suggestions or ideas on how I might need to proceed.

Thank You!

--

Best Regards,
veggiedude

Katia
Telerik team
 answered on 24 Nov 2016
4 answers
1.0K+ views
Hi,
I am working on telerik reporting. Everything is working fine except one. Reportviewer has different number of pages in display mode and in Print preview mode. If reportviewer is showing 4 pages then in print preview there will be 7 pages. I want the equal page count in every case. Please let me know what to do for this? Is there any property in the reportviewer that need to be modified or anything else?

Regards,
Sonia Shahid
Bill
Top achievements
Rank 1
 answered on 23 Nov 2016
3 answers
663 views

I would like to add in textboxes in Group Header section in the following format.

  Name   Rahul                Mobile No. 02323213                   State      TN

  Age       21                     Country     INDIA                          Senior   yes

  City     Chennai             Rin no          --------------

pls Help

 

 

             

Stef
Telerik team
 answered on 23 Nov 2016
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?