Last post Jan 16, 2017 11:58 AM by mamoni.kol2017
Jan 13, 2017 10:32 AM|mamoni.kol2017|LINK
i have experience to work with client side ssrs report where report file extension is rdlc.
normally there is two way to bind ssrs report.
1) we can fetch data from db and store those data in dataset and bind dataset to ssrs report.
2) or we can directly bind store procedure to ssrs report.
the main problem is if there is huge data then we have to pull all data and bind those data to report. ssrs report has its own pagination feature which pull data from memory i assume.
so just tell me when there is huge data and that data is stored in memory after pulling from db then this kind of situation may cause shortage of memory. so how people handle this kind of situation in real life scenario when they has to bind huge data to
looking for good guidance.
Jan 16, 2017 02:41 AM|Chris Zhao|LINK
1. Configure memory limits for the SQL Server Database Engine and the report server and verify that the memory management configuration is the correct model for your report server use.
#Configure Available Memory for Report Server Applications
2. Caching Reports
3. Don't retrieve more SQL Server data than is needed.
Jan 16, 2017 11:58 AM|mamoni.kol2017|LINK
suppose i have to show all employee data in report and there is 1,00,000 report is db. so tell me how to handle this situation. we can not do pagination at sql level because i need to pull all and bind report with those data.
so guide me.