Filter rows in SSRS based on parameter and Field

问题:

I am new to using the filters in SSRS. But I would like to filter Accessories (Yes, No). This is a parameter with a yes and no Value which would display/ filter rows based on the field Field!class.Value= "I" or "A" accordingly.
So If the drop down is yes it should only display rows with class "I" otherwise All "I" and "A" How would I do this in the Taxlib filters property. It is not working for me, the way I need it to.

Help would be immensely appreciated as usual! :)

回答1:

Modified as per OP corrected logic ..

Create your parameter Label Yes with value ="I" and No with value ="*"

In your table properties, filter section, click add button.

Below I am filtering type field against the parameter. You need to select the class field from the drop down list.