Report generation taking so much time with large data.

[Manoj]

Hi!!!!! friends
i  having around 7000 rows of records with 7 column and want to generate report using telerik reportviewer,
but its taking so much time to generate the report around 1.5 minutes.
Please suggest a simplest way to speed up the generation of report with large amount of data
using telerik reportviewer ASAP.

Thanks in advance.
Manoj Gupta

[janusz]

I have the same problem with the newest version (Q2 2010). It is not possible to create report with large amount of data. When I back to previous version (Q1 2010) everything work fine. 

Regards
Janusz Siwy


 

[Steve]

Hi guys,

As far as the processing time and consumed memory is concerned, the complexity of the report layout, the complexity of the data calculations (aggregates, conditional formatting),  the rendering media, the size of the generated document (in pages), and the capabilities of the underlying machine are crucial.

We would appreciate your thorough explanation of your scenario and a runnable sample project so we can give appropriate advise. That is why we would appreciate if you send us a sample application that we can run on our end and observe the problems you've elaborated on. Once we review it, we would be able to provide you with more info.

@Janusz - how many rows of data do you have and do you render them directly in the report or you use Table/CrossTab item?

All the best,
Steve
the Telerik team

[janusz]

Hi Steve
I use table to report up to 5 000 rows from 60 000 records readed from database. Rows are filtered using four report parameters.  
Regards

Janusz

[TechSavvySam]

Are you restricting your SQL query to retrieve only the data you need for the report (i.e. just returning the 5000 of 60,000 rows from the database)?  If you are just using Telerik reporting to filter the rows, then what is happening is all 60,000 rows are being returned to Telerik reporting and then it has to go through each returned row doing the filtering. 

For example, let us say you have just want records for a certain date range, you need to add something like this to your SQL query to retrieve the data:

WHERE RowDate>=@MinRequestedDate AND RowDate<@MaxRequestedDate

this would filter the returned data down to rows on or after MinRequestedDate (inclusive of the limit) but before MaxRequestedDate (exclusive of the limit)

You have to explicitly make this change to your query.

[janusz]

Hi Sam,

I know that restricting SQL is the best solution. It is simple when you need to use "singlevalue" parameters. But I need to filter my data using multivalue parameters. For example filter customers belonging to 3 of 10 segments.
I have no idea how to do it without creating sophisticated procedures.
 
Regards

Janusz

[Steve]

Hi Janusz,

As you can see from our Q2 release notes, the observed behavior should be the opposite i.e. the table rendering performance should be better rather than worse compared to the Q1 release and that is why your claim has baffled us.
That is why we would appreciate if you send us a sample runnable application/report that we can use on our end for testing. Once we review it, we would be able to provide you with more info.

As to your multivalue inquiry - as far as the SqlDataSourceParameters are concerned, the current implementation is based on ADO.NET and does not allow you to pass a collection of values (set, array). Thus, the SqlDataSourceParameter accepts only single values corresponding to the SqlDataSourceParameter.DbType property. Although this is a known limitation of ADO.NET, we're currently researching on possible solution for it.

Kind regards,
Steve
the Telerik team

[Kiran]

Hi Steve,

I am simply setting the datatable to the report. and it has around 250 records only. it takes around 80 seconds, No grouping, no sorting, nothing.thing is I have around 55 max columns in the report, and its upto user what are the fields they want to see, as user selected the columns I am setting  text.value = "=Fields.Value1" and rest all textboxes are visible false

Please advise

[Kiran]

I forgot to mentioned about I have three subreports, in this report, but its conditionally loaded, while testing with 250 records, there are no subreports loading in main report

[Kiran]

Please give me some idea, we have purchased the telerik reporting tool. but still can not provide the reports to our customers

[Stef]

Hello Kiran,

The processing time depends on the machine CPU and memory, and the report complexity. Custom code not generated by the designer may slow down the report generation as well.

In order to investigate the issue, please send us your project, including test data to run and profile it at our side in your support ticket on the same question.

Regards,
Stef
Telerik

[David]

I can report that the Telerik suite does work.  I am, like you, a customer of theirs who is delivering solutions to my customers.  As part of my day to day duties I code solutions using c# and the Telerik suite.  Amongst the many reports I have written, I have one which is part of a local municipalities monthly billing process.  An average cycle prints out around 880 pages.  While I personally consider it a HUGE waste of paper they still actually print the critter.  The report contains customer information, totals by service, totals by customer, and totals by report.    This report takes around 1.5 minutes of SQL query time and about 2 minutes to render.  Exporting to Adobe, in the attempt to save trees, takes around 2.5 minutes.  Exports to Excel are pretty much instant and render reports in the 18-24000 rows range.

While this sample might be larger than you are needing it should give you an idea that what you are looking for is possible.

[Kiran]

Hi Stef, I am not able to attached the project as it required more space then this website allowed, even I tried with attaching single report at a time, but its still consume 3 kb, and this website does not my attachments.
Please advise.

or can I send you the text file.(just code) ?

[Kiran]

Hi Stef, I am not able to attached the project as it required more space then this website allowed, even I tried with attaching single report at a time, but its still consume 3 kb, and this website does not  allowed that Please advise. 
 can I send you the text file.(just code) ?

Also advise how much system memory is appropriate for telerik

[Stef]

Hi Kiran,

Check your account's support history, where you can find the support ticket on the same topic. You can also use the Contact Support Team link to send us another support ticket, where you can attach your files - the limitation is up to 20MB per post. Public forums allow only image attachments.

Regards,
Stef
Telerik

[Kiran]

Hi Stef,

I hope that you have received the reports I sent you from my account support.

[Stef]

Hello Kiran,

We reviewed the provided project and sent you several suggestions to test at your side. This is a quote from my response:
"You can find attached the modified project - we added manually 250 rows to the data source of the report and it produced 36 pages for less than 10 seconds.

Based on the provided report definition, test the following at your side:

1. There are 10 static groups in the report, which can be merged into a single static group - this will save unnecessary calculations for unneeded sections;
2. Instead of arranging the layout manually, use a Table/List item with static rows and columns and place the TextBox items in the cells - the arrangement matters for the speed of measuring the items in the rendering media;
3. Move the logic from the code behind logic into expressions. For example if a TextBox.Format will depend on a field, use the built-in functions and custom functions  to bind the property. Use conditional formatting to set colors based on field's running value;
4. Move the logic where the user selects the fields to be displayed and the report modifications outside events. For example when you instantiate the report, you can get a whole section and its Items or specific item. Then set items' Value properties. Consider the example in the Access items from report, calling application and Table(Access items from calling application) article.

"

Please, let us continue the discussion in your support ticket.

Regards,
Stef
Telerik

[Maddy]

Hi,

I have 1 lack record with 20 columns  to display in telerik report.can i create such kind of report with telerik ...

 

[Nasko]

Hello Maddy,

It depends on the complexity of the report and the used machine. In general, Telerik Reporting is capable of showing 1 lakh of records with 20 columns. Depending on the report structure and the available machine resources it may take some time to render the report.

Regards,
Nasko
Telerik

[Geethika]

Hi Nasko,

It was mentioned that  report performance depends on the machine resources also.

Can you please advise how much memory and CPU will be ideal in order to improve performance ?

Thanks

Geethika

[Nasko]

Hello Geethika,

Report processing and rendering are memory intensive operations. The CPU power and amount of memory have impact on the rendering performance. Obviously, the faster the hardware, the better. For data- and layout-intensive reports, we would suggest a minimum of a dual core processor with at least 2 GB of RAM. Network traffic bandwidth also impacts performance.

Regards,
Nasko
Telerik

[Solange]

Hi, i has a report with 600,000 register and I use a  Windows server 2016 with 32 gb of memory and the report dont work.

 

[Neli]

Hello Solange,

Do you preview the report in the Standalone Report Designer (Visual Studio Report designer) or it is integrated into the application? If it is displayed through any of the HTML5 Report Viewers, you can inspect through the dev tools of the browser. You can also enable Trace Listener to the Standalone designer or to Visual Studio (refer to Visual Studio Problems article) to check for any errors in the generated log file. The reporting engine performance depends on numerous factors, so without looking at the report definition I'm unable to give a suggestion about the problem. In addition, which is the version of Telerik Reporting? 

Try to open our Product Sales demo which contains about 120 000 rows of data. You can also check the Performance Consideration article that elaborates on the subject.

Regards,
Neli
Progress Telerik