saji1982scott
Programmer
I have an SSRS reports with a master report using sub-report frames. The master report has drop-down parameter. On selection of each drop-down value the master reports calls 4 sub-reports.
I select the drop-down value(which is 1 at a time to view reports) to view reports and then to export the report in an Excel.
Once we export the reports into excel we can see 4 sheets in a single excel (represents all 4 child reports).
The problem is that I have to select 1 drop-down @ a time to export the report. Is their any way that I select all drop-down value(or a check box which makes all select) and when export then every drop-down value will be exported as an excel file and each with 4 sheets?
I can do this in C# with report builder or SSRS Subscription(10 subscription 2 different time with different default parameters) but I want to know if this is possible in SSRS.
Any suggestion would be great help towards Automation.
I select the drop-down value(which is 1 at a time to view reports) to view reports and then to export the report in an Excel.
Once we export the reports into excel we can see 4 sheets in a single excel (represents all 4 child reports).
The problem is that I have to select 1 drop-down @ a time to export the report. Is their any way that I select all drop-down value(or a check box which makes all select) and when export then every drop-down value will be exported as an excel file and each with 4 sheets?
I can do this in C# with report builder or SSRS Subscription(10 subscription 2 different time with different default parameters) but I want to know if this is possible in SSRS.
Any suggestion would be great help towards Automation.