Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2999
  • Last Modified:

How to export to excel 2007 from reporting services 2008

I am using reporting services 2008 and database on sql 2000. I have to export the report data into excel. The report contains 367 columns ( matrix report and columns are dynamic) But when I export it fails stating column limit is 256. Excel 2007 can accomodate 16000+ columns. How can I specify to export into excel 2007.
Thanks for the help....:)
0
swami_varahagir
Asked:
swami_varahagir
1 Solution
 
redrumkevCommented:
Swami Varahagir,

How are you doing?

You need to export to .xlsx (the ???x part of the file name distinguishes between 97-2003 and the new 2007 format). Otherwise, .xls format (the defacto standard in Excel) is the very limited (256 column) version.

Hope this helps,
Kevin
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now