December 19, 2008 at 12:40 pm
Hello,
I have a report made available on Report Managers that give various charts and line item information for inventory data on customers. The deal is all of the reports except one works just fine. The one that doesn't work has 309 pages for one location. The others average 100 or so for all locations. The issue is all of the other customer's data exports properly to Excel. This customer's data does not - not for all locations, not for one location. Any idea how to resolve this? Is it most likely the limitations of rows in Excel? Is there a workaround in SSRS to allow the end users to export the data and use it in Excel? The main issue is the charts. Thanks for help. Oh, also, they cannot view all locations for this particular customer although they can for others. Offhand, I would say there's a total of over 900,000 records for this customer but I wouldn't expect that to be a problem for SQL.
December 19, 2008 at 2:52 pm
There is no way for reporting services to get around limitations in excel.
your going to have to make the report send out less data.
Reporting services has many known issues with large report outputs. With data and charts.
December 19, 2008 at 3:00 pm
SSRS outputs to Excel 2003 format - which has a maximum number of rows of 65357 (I think that is the number). If you have over 900,000 records - you are going to easily exceed the number of rows in a single worksheet.
I also think there is a limit to the number of worksheets - I want to say 255, but I really don't know the exact number.
Any way you look at it - you are exceeding the limitations in Excel. Modify the report so it does not exceed those limitations.
BTW - what could one person do with 900,000 records in a report? How could that person do anything meaningful with that much data?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 19, 2008 at 3:28 pm
For EXCEL 2003:
Limits:
Reference Excel Help File
Worksheet size 65,536 rows by 256 columns
Column width 255 characters
Sheets in a workbook Limited by available memory (default is 3 sheets)
EXCEL 2007 - reference
http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH101030621033
Limits:
Worksheet size 1,048,576 rows by 16,384 columns
Column width 255 characters
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply