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 2008 - Export to excel having more than 256 colums Expand / Collapse
Author
Message
Posted Monday, June 10, 2013 12:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 4:00 AM
Points: 19, Visits: 94
hi ,

I have report in 2008 with more than 256 columns,when i try to export to excel it is giving error.
I am aware that it export to excel 2003 does not support more than 256 columns,
Is there any other way to get rid of this issue.
I dont want CSV approach,any other approach would be appreciated.

Regards,
Hemanth
Post #1461395
Posted Monday, June 10, 2013 1:55 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 12:03 AM
Points: 554, Visits: 446
Upgrading your excel version to 2007 is an only option left with you, if you want the output in excel only.
Post #1461418
Posted Monday, June 10, 2013 1:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 4:00 AM
Points: 19, Visits: 94
How do i do it.. is it need to be done at report server end?
Post #1461419
Posted Monday, June 10, 2013 2:17 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 12:03 AM
Points: 554, Visits: 446
Upgrade your excel version to 2007, (i.e. Installing Excel 2007 on your PC). Get help from your IT team.
Post #1461420
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse