Exporting SSRS report to Excel

2
votes

I am COMPLETELY new to SSRS and was thrown into the fire with this so PLEASE be patient. :D

I belieive I am certain that whatever format is used in the report is the format it will appear in when you download it to Excel (merged cells, auto wrap text, etc..). However, I have VERY A-Type Project Managers who seem to think that you can "pre-set" the formatting elsewhere (i.e. the queries) to ensure that the formatting stays consistent when exporting.

Is there somewher I can refer to that shows what can/can't be done with formatting prior to exporting into Excel so that I can go to them and definitively show them that what you see is what you get when you export?

Thank you for your patience in answering this.

Sincerely,

A Smith

2
excelreporting-services
You have no control from SSRS as to the formatting (merged cells, etc) when exporting to Excel. SSRS does it auto-magically. I'm sorry that I don't have an article to point to. With that said, if you simplify your report so that it's just a table (no header / footer or images). You'll get what your PM requests. - SQLMason

2 Answers

2
votes

Here are some links related to Export to Excel from SSRS. Sorry, I am not sure if that is what you are exactly looking for.

Merge Ahead (blogs.msdn.com)

Ensure best Excel export formating from SQL Server Reporting Services (blogs.msdn.com)