Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS - Cannot Export to Excel Expand / Collapse
Author
Message
Posted Sunday, September 2, 2012 5:46 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, August 17, 2013 7:45 PM
Points: 65, Visits: 228
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
Posted Sunday, September 2, 2012 9:42 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 5:30 AM
Points: 880, Visits: 669
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 »

Add to briefcase

Permissions Expand / Collapse