Exporting SSRS reports to excel without formatting

Try exporting/saving it as a CSV file, then open that in Excel.

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Try exporting/saving it as a CSV file, then open that in Excel.

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!