Hi Everyone, I have a data warehouse in SQL server. I have to extract data dumps from this database and send it to the concerned persons. Till now I was manually pulling the records by SELECT statements. However at present the number of such requests has increased and running them manually is taking lot of time. Hence, I tried to automate it by SSRS so that the users themselves can extract them based on their requirements. However I am facing some issues while creating the SSRS report: 1. My record count is greater than 1 million for some data extracts. 2. The time required to generate the SSRS report is more. Is there any way to fine tune it somewhere so that the report generation time reduces? 3. Once the report is generated if I try to export it, it waits indefinitely and finally it hungs. I believe it is happening due to the enormous number of records. Is there any way to handle these situations or can someone tell me some best practices of handling huge data in SSRS. Thanks

Hi, From your description, I noticed that you need to display a large number of records in the report, and now the performance need to be improved. So, I would recommend you read the MSDN document Processing Large Reports (http://msdn.microsoft.com/en-us/library/ms159638.aspx). In addition, which version of Reporting Services you are using? In Reporting Services 2008, enhanced rendering extensions are introduced that support on-demand report processing. This enhancement improves the way report processing handles large amounts of report data at run time. If you have any more questions, please feel free to ask. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Tony, Thanks for your reply. Let me explain my requirement: I have a database with more than 30 million records for 1500+ clients. And I have to filter and extract records for each client (sometime for few clients the record count is approx 1 million) and send it to the concerned person. Initially I started with SSIS and created packages for each clients and the package used to extract the data and dump it to some shared folder. However it is not feasible to create packages for 1500+ clients. Hence I thought of going for a SSRS solution where the users will select client and pull the data. However, the first challenge is to generate the SSRS report which can display 1 million record and the second challenge is that when the user downloads it, it should not get hung. I created one report with 100,000 records and tried to export it to excel. It exported successfully. However when I opened the excel file I noticed that it exported only top 10,000 records from the SSRS report. Could you please suggest any solution for this. I am using SSRS 2008.

Hi, I am giving the below point from my experience, Once the report is generated we need to export into files before some time limitation within 20 mins (hope u already done in time) 100,000 records not supported in SSRS 2008 while exporting into Excel. You have choose other formats. I use to save in CSV format it will come perfectly. As of now i saved upto 3lac to 4 lac records. While exporting into excel file in SSRS 2008 it will export/support upto 65536 records. Sridhar V Please remember to mark the replies as answers if I answered your question.

Hi, If the above suggestions are not worked for you then, I can say you will try to implement the Data-Driven Subscription method in SSRS. Follow the below link to know more about Data Driven Subscription http://msdn.microsoft.com/en-us/library/ms169673.aspx Sridhar V Please remember to mark the replies as answers if I answered your question.Sridhar