SSRS 3 : Making Drop Down Parameter with Datasets

 

Now I want to fetch data using sql query in Drop down list 

Step 1 :- Firstly  I have to create New data set for drop down list 

Step 2 :- Choose Available  Value from parameters 

Step 3 :- Pass Query in new data set 

 

Cascade DropDown Report

Part 4: Conditional Formatting & Parameter Wise Formatting