SSRS Cannot Export to Excel

  • 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.

  • 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.

  • 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

  • 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

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply