Report Taking a long Time to load and Render

[akpaga akpaga]

Hi Friends,

I ahve a report which is 10 columns wide.The problem is that though the report loads with a little delay....and when it loads and i Try to
use the scoll bar of the report viewer to drag to other columns it starts to render again for a long time ...and then i am able to use the whole report after some time..Why is it doing like that?

PS:  There is a warning on My reprot deisgn..Saying that report is to wide to fit on a single page...Does this have  anything to do with my problem..Please guide me...Thank you

[Steve]

Hello,

We will need more information about your configuration and the report layout in order to pinpoint the reason for the slowdown. 

1. What is the report layout you are after? For table like layout we highly recommend Table item that is optimized for such layout and performs better than table like layout with textboxes. 
2. Please elaborate on the current rendering times and the target rendering times.
3. Do you have horizontal paging? Our current implementation of horizontal paging of CrossTab/Table (occurs when the report does not fit on one page horizontally) has major impact on the performance. i.e. if you have 1000 pages high report, and horizontal paging appears, you will feel like paging not 1000 * 2, but ~ 1000 * 1000 pages. The bottom line is that in order to page long reports you should avoid horizontal paging at all costs.
4. The page count could also cause a delay if you are using the PageCount global object. 
5. Additionally we will appreciate if you elaborate on the server configuration OS, CPU, RAM and etc.

Be aware one has to keep in mind that handling reports (be it with large data or large number of report items) usually requires additional resources to handle all the operations. Those operations are complex and include data processing (aggregates, filtering, sorting, conditional formatting, expression evaluation, events) and rendering (fonts measurements, layout calculations, paging and etc.).

We highly recommend reviewing Performance Considerations KB that shares some general performance tips. Let us know how it goes and in order to investigate further we will appreciate if you send us the report definition and some dummy data to debug locally.

All the best,
Steve
the Telerik team