SSRS 2008 R2. Print Reports In sequential order

Question

SSRS 2008 R2. Print Reports In sequential order

myjobsinus

SSC Eights!

Points: 964
More actions
September 26, 2013 at 8:56 am

#278385

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.

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

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

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

myjobsinus SSC Eights! Points: 964 More actions · Answer 2

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.)

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

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

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 4

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

Raunak J