SSRS - Cannot Export to Excel

  • Hey everyone, I'm trying to export a report in report manager and I'm getting an error saying "An error occurred during local report processing. Excel Rendering Extension: Number of columns exceeds the maximum possible columns per sheet in this format; Columns Requested: 268, Max Columns: 256."

    Upon doing some research, it looks like Excel 2003 only supports 256 columns. However, I have Excel 2010 installed on my machine, so this excuse does not suffice. Is there anyway to circumvent this? I spent a month building this report and I need to get this deployed asap. The report was built for Excel export, and does not render properly in other formats (PDF, MHTML, etc). It's been increasingly frustrating...

  • Which version visual stdio is in installed in your system.

    because visual studio upto 2008 version ssrs excel export have only 2003.

Viewing 2 posts - 1 through 1 (of 1 total)

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