How to fetch record in multiple datasets in SSRS

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.
Last updated:4/2/2016 4:44:58 AM

1 Answers

Anupam Mishra
Anupam Mishra

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

Answer