We will be using SQL Server 2012 Reporting Services in our application and we have nearly 20-25 reports in our application.
We want to use Master report which will hold other sub reports. We want to know if we will be able to change the order of sub reports in the final report dynamically at run time based on certain parameters for specifying the order based on user preference.
Please confirm if this feature is supported in SSRS 2012 as soon as possible. Please let me know if you need any further information.
In Reporting Services, we can set sort expressions on a Tablix data region or a group, including the details group to control the order of the records inside the tablix at the running time. However, we cannot control the order of report controls (tablix,
textbox, chart,subreport, rectangle……) at the run time currently. So in your scenario, there is not such a functionally to work around this requirement.