|
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.
(comments are locked)
|
|
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. An option you may wish to try is exporting to CSV then opening with Excel.
Aug 04 '11 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 '11 at 12:54 AM
GPO
Thank You.
Aug 05 '11 at 07:39 AM
sandvarma
(comments are locked)
|
|
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.
(comments are locked)
|
