How do I connect two datasets in one SSRS report

Posted on 2009-04-24
Last Modified: 2012-05-06
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?
Question by:Bubie
    LVL 9

    Expert Comment

    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.
    LVL 4

    Accepted Solution

    Vikram, I think you are wrong. In 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>
    2. Define a second, third ... dataset that has it's own query and requests BILLTo or whatever you need.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    This video discusses moving either the default database or any database to a new volume.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now