x

Rendering a report from report manager to excel

Hi,

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

sandvarma gravatar image

sandvarma
41 2 2 3

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

2 answers: sort newest

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][1].

[1]: http://msdn.microsoft.com/en-us/library/ms153624.aspx
more ▼

answered Aug 09, 2011 at 02:05 PM

grrl_geek gravatar image

grrl_geek
866 1 3

(comments are locked)
10|1200 characters needed characters left
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

Tim gravatar image

Tim
36.4k 38 41 139

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x558

asked: Aug 04, 2011 at 06:06 PM

Seen: 1322 times

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