question

nsaireddymca avatar image
nsaireddymca asked

Export SSRS Report to Exclel 2003 is taking long time in SSRS 2008 R2?

Hi , i did several reports in ssrs 2008 r2 which contains records around >4 lack .i did page break for every excel sheet for every 65k records. when testing people tried to export to excel 2007 then it is opening within 20 minutes but if they tried to export to excel 2003 then it is taking more than 50 minutes time but still it is not opening. how do i fix this issue? thanks in advance?
ssrs-2008ssrs-2008-r2
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nsaireddymca avatar image nsaireddymca commented ·
hi, my client is using office 2003 , so they is not willing to upgrade office 2007. and our report should open in excel-03 , in case of office-07 it is opening 4 lac records very soon by splitting 65000 records per excel sheet. but the same process is taking more than 2 hours to open in excel-03. how do i over come this issue.
0 Likes 0 ·

1 Answer

·
tanglesoft avatar image
tanglesoft answered
Excel 2003 has a limit of 65535 rows so are you putting in page breaks so each appears in it's own worksheet?. How many pages are there in total?. What happens if the file is saved from Excel 2007 and then opened from Excel 2003?
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

bmcdonald avatar image bmcdonald commented ·
I created an XLSX file with a SQL Server connection and a parameterised query. I deployed the xlsx file to reporting services. The user should enter the date parameters and the data is returned in one sheet. No pages
0 Likes 0 ·
tanglesoft avatar image tanglesoft commented ·
Hi Bit confused here. Microsoft Excel 2003 does not support XLSX files. Also what do you mean when you say you deployed an XLSX file to reporting server as you can only deploy RDL (Report Definition Files). If you have deployed a report in SSRS 2008 it will only output old style XLS files with the 65536 limitation. You have to use next version of SSRS to get XLSX files as the standard output format. If the users have Microsoft Excel 2007 or greater on there machines it will open the XLS file generated by generated by SSRS as this is default application for XLS files. When the report is open you will be able to see [Compatibility Mode] in the title. It's likely that Excel 2007 is more efficient at loading the file that the older version. However if the file is more than 65536 rows the old version will never load it.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.