How to fetch record in multiple datasets in SSRS

Total Post:26

Points:182
 1043  View(s)
Ratings:
Rate this:
Hi Everyone,

I have three datasets in different database and i want to display those records at one place.
and records are show in tabular form using SSRS.
Please anyone give me a solution.

Thank you.
  1. Post:135

    Points:949
    Re: How to fetch record in multiple datasets in SSRS

    Hi Simond,


    Here we are selecting three databases for displaying data in tabular form.These are below with report diagram:



    For Adding datasets :



    Similarily, we adding the rest two datasets.

    Output


    For more details : 
    1. https://www.mindstick.com/forum/34090/how-to-create-sqlserver-reporting

      Modified On Apr-11-2018 03:33:46 AM

Answer