Hi Experts, I have SQL Procedure resulting 10,000 records, which is properly indexed and working fine from db. Using SSRS 2008 recreated a report to print the records with some parameters. Problem : The SSRS Report Viewer Control and even Report Manager is loading all the records in 1 page, which is taking very long time to show and scroll. Please suggest how can improve the performance. (Creating Paging??? etc) I appreciate some quick solution. SA

Hi, If you are using HTML rendering, you can use interactive height property to specify soft page break in HTML. So only some of the records will be rendered. You can set interactive height from Report Properties. -Chintak

I already used the Property Interactive height set to 11.27", which is working fine when printed and exported. But the problem is when report viewer outputs the result. Please suggest...

Any suggestions, please... Even the report manager and report viewer control renders all records in one page. which is taking much more time. Is there way to have paging automatically like crystal report does. Thanks...

Hi, So, Its looks like your Interactive page braeks are not working. These settings needs to be done in report defination, this is not report viewer setting. Can you check if you have "keep togather" property is checked in tablix property? If this option is selected then whole page might be loaded. Hope this helps-Chintak

EXCELLENT... Chintak, that was the problem. Thank you very much for your time..

Hi Prasad, Have you checked your InteractiveHeight property of your report? This causes a soft pagebreaks. KeepTogether tablix property, which overwrite default behieviour. -Chintak-Chintak