filmov
tv
SSRS Report with SQL Procedure | Part 6

Показать описание
SSRS Report with SQL Procedure:
Requirments: SQL SERVER 2012, SSDT tool installed for SSRS and visual studio 2015.
Steps:
1. Add a Shared Data Source and established the connection to SQL server using the credential with database name.
2. Create a Dataset: We define the SQL queries, and if any parameters are required, we write the SQL query with parameters.
3. Create a Report and 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.).
SQL Procedure in SSRS:
Procedure name: sp_emp_detail
Requirments: SQL SERVER 2012, SSDT tool installed for SSRS and visual studio 2015.
Steps:
1. Add a Shared Data Source and established the connection to SQL server using the credential with database name.
2. Create a Dataset: We define the SQL queries, and if any parameters are required, we write the SQL query with parameters.
3. Create a Report and 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.).
SQL Procedure in SSRS:
Procedure name: sp_emp_detail