forum

home / developersection / forums / how to fetch record in multiple datasets in ssrs

Ask Question

How to fetch record in multiple datasets in SSRS

Simond Gear 2707 02-Apr-2016
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.
reporting reporting  sql server  reporting services 
Updated on 02-Apr-2016
Simond Gear

Simond Gear

Follow

Can you answer this question?
Answer

1 Answers

Anupam Mishra

Anupam Mishra

02-Apr-2016
Hi Simond,

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

How to fetch record in multiple datasets in SSRS

For Adding datasets :

How to fetch record in multiple datasets in SSRS

Similarily, we adding the rest two datasets.

Output

How to fetch record in multiple datasets in SSRS

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

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy