Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ambi6088
Starting Member
4 Posts |
 Posted - 2011-08-09 : 02:22:41
|
| Hello!!!Is there any limitation on SSRS 2005 reporting service to handle maximum upto some # of record to render?My SQL execution time is 90 Sec which returns me 300,000 records approximately and my RDL is not having any grouping / sorting but i am not able to load the report. Its failing to render the report. Thanks in advance,Regards,Ambi |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-08-09 : 08:10:15
|
| Why would you possibly want to display 300k records in SSRS?? What is the error message? The problem is probably due to hardware limitations. Rendering 300k rows will take quite a bit of memory...- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-09 : 10:22:16
|
| are you trying to render it any other format like Excel or something?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSRS 2005 failing to render large data