Automatically Export SSRS Report into Excel Template

Question

We have an existing Excel template with multiple worksheets, a macro, and several formulas.

Can you automatically export an SSRS report into the template as follows:

1. Run from SSRS menu along with other reports.
2. Specify a date range parameter.
3. Automatically export the report data into a specific worksheet and range in the existing template.
4. Run the template's macro.
5. Have the template generate a resulting XLS file, named using the date range parameter.

If not, how automated can I make this?

I know I can create a utility in .Net for this, but the we would prefer to run it from SSRS, as it is considered a report by the client. Also, we don't want the user to have to copy/paste, import, etc. They just run the report, specify the date range, and go.

Answer 1

Hi @Anonymous

Unfortunately, SSRS does not have great support for templates/style.

If you want to add the report into an existing excel, it is not possible to add sheets of report in already existing Excel. It will just overwrite on that excel and already existing sheets will be deleted of.

If I misunderstand your issue, please incorrect me.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

SSRS exports a report as the report is design, it's not possible to use a kind of template with a different design.