How to use data from two different datasets from two different servers in SSRS 2008 R2 RTM?

  • Hi – we have datasets from two different servers in our report and in the design, we have table and would like to add another matrix inside the table. Since the main table is using a Dataset A, it’s not allowing me to add the columns that are available in Dataset B which has different data source than Dataset A.

    After done some reading on Blogs, it can be achieved using Linked Servers but in our case – due to some access issues, couldn’t go with Linked servers.

    Can you please suggest some other best way to achieve the same?

  • If you have a linking column, which I'll assume you do, you can use a Lookup to pull the data from the second dataset.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply