Tuesday, January 28, 2014

SSRS and raw data

I have a web-based application with SQL database in a back-end. But the problem is with raw data.


I need to make it available for all users (500+) so along with normal summary SSRS reports I have created some details one where I list all data (50 000+ rows). But as these detail reports are used very often they generate a lot of traffic on the server and users often get an error while exporting it to Excel because RS is running out of memory.


Is there any better way to make live raw data available to large number of users other than creating big detail SSRS reports?


No comments:

Post a Comment