SSRS - Cannot Export to Excel

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SSRS - Cannot Export to Excel

SSRS - Cannot Export to Excel

Rate Topic

Display Mode

Topic Options

Author

Message

dj1202

Posted Sunday, September 02, 2012 5:46 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, March 28, 2013 1:20 PM
Points: 65, Visits: 219

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

Post #1353292

subbareddy542

Posted Sunday, September 02, 2012 9:42 PM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 8:18 PM
Points: 832, Visits: 610

Which version visual stdio is in installed in your system.
because visual studio upto 2008 version ssrs excel export have only 2003.

Post #1353317

« Prev Topic | Next Topic »

Permissions