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