• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 544
  • Last Modified:

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?
1 Solution
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.
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.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now