SSRS_Parameter and Cascade Parameter Report.

Create Parameter Report:

To get the category as drop down.

When you have to choose multiple values , you make the below changes in the Query.

     Create Cascade Parameter Report:

Cascade Parameters means dependent parameter.

Ex: Create dataset with following:

USe IBank

go

SELECT ACID,CustomerName,BRID, PID

FROM AccountMaster

WHERE BRID=@BRID and PID=@PID

·         First we need to add 2 parameters in our main SQL query (MainDataset). Once added it will automatically add in the Parameters in Report Data window.

·         Create new datasets to get the values in the 2 parameters.

o   We need to get all the distinct values in the 2nd parameter.

 

Ex: SELECT DISTINCT(BRID) FROM AccountMaster

 

o   We must need to add the WHERE clause in the 1st parameter which means second parameter is dependent on first parameter.

Ex: SELECT DISTINCT(PID) FROM AccountMaster WHERE BRID=@BRID

Setting to show the Column Headers on each page :

Report Template:

·         Create a Report with a Page Header and Page Footer.

·         Copy the Template to below path to make it as template.

·         SQL server 2017

·         C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

 

4)