Rendering a report from report manager to excel


Iam trying to export a report from report manager to excel ,it throws me an error saying that the report exceeds the limited no of columns 256. Later I figured out that by default it exporting to excel in XLS format which is excel 2003 version and has the limit of 256 columns. For excel 2007 which is xlsc format , it can take max no of columns 6536.. . So if we can default the report manager to export into excel in a .XLSC format , the problem is solved.

Please help me , how to make it work.

Thank You.

more ▼

asked Aug 04, 2011 at 06:06 PM in Default

avatar image

41 2 2 3

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

This is an issue with SSRS 2005/2008. Both utilize Excel 2003. Denali is rumored to use a newer version of Excel. I have CTP3 installed on a VM I will fire it up and do some testing but it might take me a day or two to invest the time.

more ▼

answered Aug 04, 2011 at 06:17 PM

avatar image

40.4k 39 84 166

An option you may wish to try is exporting to CSV then opening with Excel.

Aug 04, 2011 at 06:43 PM Tim

The other option to explore is the orange "export to data feed" icon which I believe is new in SSRS 2008R2. When I first saw it work (I think you need power pivot to get value out of it) my first reaction was "When people said they wanted to export from a report to Excel THIS is what they meant." Most people in my experience are heartily frustrated with the merged cells and resized columns that accompany an export to excel. They want to export to excel to get at the data. The care factor about the formatting comes a distant second.

Aug 05, 2011 at 12:54 AM GPO

Thank You.

Aug 05, 2011 at 07:39 AM sandvarma
(comments are locked)
10|1200 characters needed characters left

Another option would be to implement a custom rendering extension in Reporting Services. You can find some information about there here: http://msdn.microsoft.com/en-us/library/ms153624.aspx.

more ▼

answered Aug 09, 2011 at 02:05 PM

avatar image

866 1 3 7

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 04, 2011 at 06:06 PM

Seen: 1644 times

Last Updated: Aug 04, 2011 at 06:06 PM

Copyright 2016 Redgate Software. Privacy Policy