SSRS 2008 R2- exporting the report to excel
hi,
i have some 1.5 million records in a report and since i cannot export the entire records into excel format i added the page Breaks.. i created a group and then added the following code in the group expression
=ceiling(rownumber(nothing)/10)
this resulted in losing some records.. is there any solution to solve this problem and i want the entire records to be given across different pages.
June 13th, 2012 2:22am
Hi,
When we export a report to Excel format, the maximum number of rows in a worksheet is limited to 65,536. This limitation is caused by the BIFF's format capabilities. Besides, it is recommended to limite the rows to less than 60,000 rows on each worksheet
to avoid unexpected issue. So, you can modify the group expression as follows:
=Ceiling(RowNumber(Nothing)/25)
Reference:
Exporting to Microsoft Excel
Regards,
Mike Yin
Free Windows Admin Tool Kit Click here and download it now
June 18th, 2012 1:17pm
Hi Mike,
Thanks for the help.. but I am still facing the same issue.. actually the excel sheet shows two sheets.. one is with <1million records( actually it has to show more than 1 million record) and another page shows "End of the report"
textbox alone..
Please correct me if the process of creating the group expression is wrong.. I created a new group on the table and deleted the default group and gave the expression as
=Ceiling(RowNumber(Nothing)/25) .
I really dont know where i went wrong. can you please help me with this?
June 19th, 2012 2:07am
Hi There
you need to make sure that this group is top group and did you right click on group and set page break on each instance of the group
=Ceiling(RowNumber(Nothing)/25)
Many thanks
Syed
Free Windows Admin Tool Kit Click here and download it now
June 19th, 2012 3:21am