How do you create a shared dataset in SSRS?

For creating a shared dataset in the SSRS, following steps needs to be followed:

• Click “Add Dataset” from the report data pane.
• The Query page containing the dataset properties opened in a dialog box
• In the “Name” field, you can select the name of the dataset, or you can use the Default name.
• Now in the “Data Source,” browse and select the name of existing data sources, or you can create the “New” data source.
• From here, you have to select the Query type option, make sure these options depend on the data source type.
  • Select “Text” to write a query using any query language
  • Select “Table” to return the fields in a database table
  • Select “Stored Procedure” to run the already stored procedure by its name
• Now click on the “Query Designer”, this will open the graphical query designer tool.
• Click on “Import” which will show the list of all the queries from an existing report.
• That’s it, then click on OK.