Hi,
Please help me.
I need to export around 1 million records to excel. As we know that there is a limit of approx 65,000 rows in one worksheet so the exporting functionality is failing. One way is that I should be able to configure the Reporting Service in such a way so that once 65,000 records gets populated in the first worksheet, then the rest 35,000 records gets popultaed in the second worksheet.
I am not able to find out how this can be achieved in Reporting Services. Please help me in this.
Thanks in advance.
Regards
Raman
Hello Raman,
Take a look at this link, in the 'Page Breaks' section, it may help you.
http://msdn2.microsoft.com/en-us/library/ms157328.aspx
It requires that you set a group with a group expression on X number of rows, then you page break on the group.
Hope this helps.
Jarret
