June 18, 2019 at 3:39 pm
I'm dealing with a requirement that states all reports created in SSRS must be exported to and saved as an Excel version. However, setting up the subscription to use the native export to Excel function isn't adequate because the layout doesn't always carry over cleanly to Excel and there needs to be predefined settings with the print settings that do not carry over as well. A thought I had was to create a template in Excel for each report, set the subscription to export to a data feed, and then have a program open each template in order to refresh the data using an OData Feed connection and save the final report. As a side note, I'm dealing with an issue where exporting to a data feed isn't an option that I have a post for over on the SSRS 2106 forum https://www.sqlservercentral.com/forums/topic/export-to-data-feed-missing. Does anyone have experience doing something similar to know if this seems like the best solution? It definitely adds more steps but is the first step in moving all reporting to SSRS.
June 19, 2019 at 11:57 am
Are you just exporting a dataset, or are is there more involved? If the former, you could create a template Excel file, and then use SSIS to create a copy of that template and export to that copy.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 19, 2019 at 12:06 pm
There will some data manipulation to create matrices, charts, etc. From what I've read this can act as a source in Excel. The SSRS output will mirror the Excel version.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply