SSRS Report with parameter using shared data source and shared datasets | Part 4

SSRS Report with parameter using shared data source and shared datasets:
Requirments: SQL SERVER 2012, SSDT tool installed for SSRS and visual studio 2015.

In SQL Server Reporting Services (SSRS), shared data sources and shared datasets are used to manage data and queries for reports.
Steps:
1. Create a New Report though SSDT or visual studio under business intelligence.

2. Add a Shared Data Source and established the connection to SQL server using the credential with database name.

3. Create a Dataset: We define the SQL queries, and if any parameters are required, we write the SQL query with parameters.

4. Design the Report: Drag the dataset fields (e.g., empid, emp_name and etc.) from the Report Data pane to the report design surface and Format the report as needed (e.g., tables, matrices, charts, etc.).
When you will select dataset when you design the report, parameter will show in the Report Data pane if you define the parametric SQL query.

SSRS report with multiple parameters: