Is there anyway for me to add in a VBA code that would take effect, when the SSRS report is exported into excel. I have a report (main report) with 4 (sub reports). All reports are in portrait, except for one. I would like to know if SSRS supports the VBAs from SSRS to Excel. Would this work? Essentially that VBA would automatically change the orientation for 1 of the excel sheet from Portrait to Landscape.
Asked
Active
Viewed 521 times
0
-
1It is not possible using SSRS. For the requeriment you mention I'd create an Excel template with all VBA code needed, then use SSIS - C# to inject the data from the database. – alejandro zuleta Oct 03 '16 at 20:11
-
Thanks. I figured as much as well, but needed to confirm. – a415 Oct 04 '16 at 14:00