Combine Multiple SSRS Reports - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Combine Multiple SSRS Reports

Author

Topic

Alvin_SQL007
Starting Member

12 Posts

Posted - 2014-01-27 : 17:27:37

Hi All,

I have 2 different SSRS reports as following.

Report 1

Customer--------------Orders--------------Order Date

Customer A ---------------5-------------------01/01/2014
Customer A ---------------2-------------------01/11/2014
Customer B ---------------7-------------------01/15/2014
Customer c ---------------4-------------------01/19/2014

Report 2

Customer --------------Order Totals

Customer A -------------------$2478.44
Customer B -------------------$487.36
Customer C -------------------$7896.93

Now i want to combine these 2 reports into 1 as following so that our client can print both the reports for same customer and post it out to them. without having to manually run multiple reports , print them and put into a package to send out by post.

Combined Report

Customer A

Report 1

Customer--------------Orders--------------Order Date

Customer A ---------------5-------------------01/01/2014
Customer A ---------------2-------------------01/11/2014

Report 2

Customer --------------Order Totals

Customer A -------------------$2478.44

--next page

Customer B

Report 1

Customer--------------Orders--------------Order Date

Customer B ---------------7-------------------01/15/2014

Report 2

Customer --------------Order Totals

Customer B -------------------$487.36

--next page

Customer C

Report 1

Customer--------------Orders--------------Order Date

Customer c ---------------4-------------------01/19/2014

Report 2

Customer --------------Order Totals

Customer C -------------------$7896.93

--------------------------------END--------------------------

Any idea how i can get this done, i have tried to use sub reports but not able to split the data within subreports for specific customers. any help will be appreciated.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-01-28 : 03:32:10

You need to add new SSRS report and add grouping on customer and select put a page break after property. Inside grouping add two rows with single columns,. Add subreports inside them and call the child reports passing customer field name (Fields!Customer.Value) as parameter value.
Make sure you add the parameters to child report beforehand for receiving the customer value and use it to filter the results for both the reports

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Alvin_SQL007
Starting Member

12 Posts

Posted - 2014-02-13 : 11:19:32

Hi Visakh,

thanks for your reply. solution worked like a charm. appreciate your help.

Alvin

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-02-13 : 12:24:55

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources