June 14, 2011 at 12:40 pm
Can anyone shed any light on why the SSRS 2008 still only outputs in Excel 2003 format.....I am a very new user and many of my business units require their respective reports in Excel format for futher analysis. Many of the reports being provided produce more than the 65,000 record max for Excel 2003 and the .csv format is a bit of a pain for them.
Just curious why 2008 would not have adopted the Excel 2007 version for the output.....
June 15, 2011 at 2:27 am
They are two different products developed by two different team within MS , cross product compatibility is not a given. As for the issue your facing , you can
Download a csv and perform text to column
use ODC to fetch data in filtered format to a pivot table.
use Business objects BO 4.0 etc for reporting
June 15, 2011 at 5:41 am
I appreciate your response.......It is a shame ( actually a "MS" shame) that version backward compatibility remains to be an issue, but then again it IS MICROSOFT).
Being a newbie, I'm not quite sure of some of your acronyms, but....
It is actually simpler than that.......
I just export the file in .csv format and let the end user open the file in Excel 2007 using the "comma" delimiter and then save it in the Excel .xlsx format.......It's simply irritating that because of the lack of foresight on the part of the development team(s), an extra step is required....
Thanks, again for your response....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply