SQL Server Reporting Services 2012 - Ordering of subreports dynamically


  • Hi,

    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.



    Wednesday, July 24, 2013 10:44 PM


  • Hi Sridevi,

    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.

    If you have any concerns about this feature, you can submit a feedback at and hope it is resolved in the next release of service pack or product.

    Thank you for your understanding.

    Charlie Liao

    If you have any feedback on our support, please click here.

    Charlie Liao
    TechNet Community Support

    Thursday, July 25, 2013 2:58 AM