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.
Microsoft SQL Server · SSRS - SQL Server Reporting Services · · ·
Currently, Reporting Services only can export a report to xls format.
However, this has been rectified in Denali (latest version of SQL Server), and I can already see that docx and xlsx are supported in CTP3.
Thank You Jason.