Add filter on SSRS report

1. Add parameters.

2. I have the following properties.

3. Right click and select properties.

4. Select the filter tab, then, add. Key in the filter that you will like to have. You can make use of the drop down list or you can set your own expression.

5. In the value column.. click on fx

6. Then click ok.

7. View at the preview.

8. Test it. Uncheck the null check box, key in ‘1’ and click view report.

9. Done.


How to create SSRS Report.