---
title: "How to fetch record in multiple datasets in SSRS"  
description: "How to fetch record in multiple datasets in SSRS"  
author: "Simond Gear"  
published: 2016-04-02  
updated: 2016-04-02  
canonical: https://www.mindstick.com/forum/34094/how-to-fetch-record-in-multiple-datasets-in-ssrs  
category: "reporting"  
tags: ["reporting", "sql server", "reporting services"]  
reading_time: 1 minute  

---

# How to fetch record in multiple datasets in SSRS

Hi Everyone,\
I have three [datasets](https://www.mindstick.com/articles/13138/tableau-training-the-soul-of-datasets) in different [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) and i want to display those [records](https://www.mindstick.com/forum/34640/how-to-create-a-stored-procedure-for-display-all-records) at one place.and records are show in tabular [form](https://www.mindstick.com/forum/6/multi-form-mfc-application) using SSRS.Please [anyone give me](https://answers.mindstick.com/qa/41194/can-anyone-give-me-some-high-and-low-points-of-each-of-the-four-first-presidential-administrations) a solution.\
Thank you.

## Replies

### Reply by Anupam Mishra

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](https://www.mindstick.com/mindstickforums/64e9b4b9-9799-491c-9ff5-cbe131e674a3/images/0cb45210-faf1-49c1-9f85-a3b01512ed78.png)\
\
**For Adding datasets :**\
![How to fetch record in multiple datasets in SSRS](https://www.mindstick.com/mindstickforums/64e9b4b9-9799-491c-9ff5-cbe131e674a3/images/df5121a9-0fa5-435a-b647-a156d003d37f.png)\
\
Similarily, we adding the rest two datasets.**\****Output****\**![How to fetch record in multiple datasets in SSRS](https://www.mindstick.com/mindstickforums/64e9b4b9-9799-491c-9ff5-cbe131e674a3/images/95b72c5b-4421-4da8-8ad4-5eece9e300db.png)**\**For more details :

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


---

Original Source: https://www.mindstick.com/forum/34094/how-to-fetch-record-in-multiple-datasets-in-ssrs

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.