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.
| 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
|
|
|
|
|
|
|
Combine Multiple SSRS Reports