SSRS: creating a report optimized for exporting to Excel?
I have a client that needs a particular report that he can export to excel. I haven’t started to build the report, but I’m thinking the best way to do this is to keep the report as simple as possible. This way, when the client exports the report, it should be relatively clean.
Does anyone have any recommendations? I already have a report created for him. I plan to make a separate report with the sole purpose of exporting to excel.
Edit: I should also mention that the original report is a straightforward report. It has some groupings, report header and footer, description (text box). I plan to remove all of these for the excel-optimized report.
