We help IT Professionals succeed at work.

How to export to excel 2007 from reporting services 2008

Medium Priority
3,009 Views
Last Modified: 2012-05-06
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....:)
Comment
Watch Question

CERTIFIED EXPERT
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.