SSRS returned data too large -- sql server reporting services

Rob
5/31/2007 10:25:01 AM

I had a quick question regarding SSRS 2005 and the amount of data my reports
generate.

Is there any way to limit the report to only pull back the first page (or
first 5 pages) of data to a report?

Some of these reports bring back 50+ pages worth of data and I am getting
complaints that they take too long to generate. The obvious solution is to
add additional parameters to limit the amount of data; but I was going to see
if there was any configuration setting in SSRS for this.

Thanks for any input.

EMartinez
5/31/2007 4:13:39 PM

[quoted text, click to view]

As far as I know, there is not; however, you can change the report
query/stored procedure to only return the top x number of rows (i.e.,
select top x * from ...) where x is the allowable number of rows to
represent in the report. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

sql server reporting services : SSRS returned data too large