SSRS Report with like parameter | Part 5

SSRS Report with like parameter:
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. 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.

SQL QUERY with Like statement in SSRS:

SELECT emp_delhi.*
FROM emp_delhi
WHERE (emp_name LIKE '%' + @emp_name + '%')