We're starting to convert local InfoMaker reports to SSRS as well as creating any new reports in SSRS. The issue we're running into is that many of our users are accustomed to saving a report to excel where they can view and manipulate the raw rows and columns of output from the stored procedure. It seems when you saved an IM report, the rows and columns all displayed as if the sp had just been run - no formatting or grouping that happened in the report.
But the SSRS reports are different. When I export a report to excel, it preserves formatting and groupings. Has anyone discovered a way to get the raw data behind a report into a plain ol' spreadsheet after it runs in Tess?
thanks,
Brian
Brian,
Saving or opening as a CSV file has done the trick for us. That was a big issue here as well, and a user discovered saving as CSV instead makes it possible to sort and manipulate as before.
Teresa