How to get Values form using paramters in Sql Report Builder

See more:

SQL-Server

SQL-Server-2008

, +

Hi to all,

This is siddiqali working on SQl Report Builder for the first time. I have two parameters one named as "Class" and other named and "Section", I should get the values based on 3 condition

Condition 1: When I select only "Class" and click on View Report Button I should get report ,But with out selecting any "Section" Parameter .

Condition 2:Here When I select only "Section" and click on View Report Button I should get report ,But with out selecting any "Class" Parameter

Condition 3:Here When I Select Both parameters and click View Report Button I should get report based on 2 parameters

In the above 3 conditions I am able to do it only 3rd condition