SSRS 2008 R2. Print Reports In sequential order

  • Hi All,

    I have 2 reports with following layout

    Sales Report

    Agent1

    State..........................sales amount-----------------Number of items.......................Average Sales

    VA................................$25000.....................................10.........................................$250.......

    CA................................$35000.....................................10.........................................$350.......

    Agent 2

    MN................................$15000.....................................10.........................................$150.......

    Performance Report

    Agent1

    Date..........................Number of calls-----------------Total time spent

    01/01/2013.....................45..........................................450

    02/01/2013.....................85..........................................850

    Agent2

    01/01/2013.....................10..........................................200

    02/01/2013.....................50..........................................600

    Now i need a third report which will combine both the reports and lets users print reports sequentially for each Agent as following

    Combined Report

    Agent 1

    Sales Report

    State..........................sales amount-----------------Number of items.......................Average Sales

    VA................................$25000.....................................10.........................................$250.......

    CA................................$35000.....................................10.........................................$350.......

    Performance Report

    Date..........................Number of calls-----------------Total time spent

    01/01/2013.....................45..........................................450

    02/01/2013.....................85..........................................850

    Agent 2

    Sales Report

    State..........................sales amount-----------------Number of items.......................Average Sales

    MN................................$15000.....................................10.........................................$150.......

    Performance Report

    Date..........................Number of calls-----------------Total time spent

    01/01/2013.....................10..........................................200

    02/01/2013.....................50..........................................600

    And part of the problem is i have to use existing RDLs only. i can not rewrite the logic as i have a series of reports(10-15) that i need to add to the requirement. any kind of help is appreciated. Thank you in advance.

  • Seems to me you need to play around with subreports and passing parameters to these subreports so that you only get information for one agent.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen,

    Thanks for your interest.

    I tried the sub report with Agent Parameter approach and it worked for one Agent at a time. But when i pass multiple Agents then sub report 1 shows all the agents followed by 2nd sub report which does the same.

    my intention is to display both the reports for agent 1 and then for agent 2 in sequential order. (as displayed in my original post.)

  • I'm not 100% sure thas can be done easily in SSRS itself.

    Might be possible with some .NET though.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • You can create two tablix regions in the report body with distinct data sets and group the report datasets by Agent Name.

    Raunak J

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply