How do I connect two datasets in one SSRS report

I have two datasets:

One that gets the invoice details.
The other gets the respective customer's BILLTO and SHIPTO address.

How do I connect both the datasets together in one report?
BubieAsked:
Who is Participating?
 
MPKRConnect With a Mentor Commented:
Vikram, I think you are wrong. In ADO.net you might have datasets containing multiple datatable, but not in SSRS.
In Reporting Services you can go two ways.
1. Change your Customer Data View/query, so that it contains the BILLTO and SHIPTO adresses in every Datarow (redundant), if this is possible. So you just need one single dataset.
A similar scenario is discussed here> http://jagbarcelo.blogspot.com/2007/04/partial-multi-column-reports-in.html
2. Define a second, third ... dataset that has it's own query and requests BILLTo or whatever you need.
0
 
VikramMullickCommented:
Think in terms of datatable not dataset.
In the SSRS , create one dataset object , which will contain multiple datatable , i..e from Billto and Shipto.
Once the datatables are filled up with data , you can proceed  normally.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.