Filter rows in SSRS based on parameter and Field

2019-09-15 18:43发布

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条回答
做个烂人
2楼-- · 2019-09-15 19:23

Modified as per OP corrected logic ..

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

enter image description here

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.

enter image description here

查看更多
登录 后发表回答