April 5, 2010 at 3:14 am
I have a stored procedure the returns more than 90,000 rows. On generating the report I get some exception and report doesnt get generated.
Is there a limit of maximum number of rows that can be handled by SSRS-2005?
April 19, 2010 at 9:13 am
Not that i know of, however be aware of how this would look in Excel (which wouldn't fit) or PDF, or even the time it would take to run the proc/query, get the data and pass into the users IE...
Any reason why its 90,000 rows? How will you use this data?
There are limits to the actual size of the rdl file but not the data itself...
April 19, 2010 at 10:16 pm
The report shows the annual report of the sales for the company. We usually get around 65000 rows.
Is there a possiblity of connection timeout while generating the report?
April 19, 2010 at 11:47 pm
Yes there is, when creating the dataset there is a timeout option which by default is 30 secs, change to 0 for unlimited...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply