BLOG

Reporting Services (SSRS) OR Filter Logic

21-03-2019  0 Comment(s)

 I am working on having a sales meeting and want to include the local sales people along with some of my top performers.  I would create a report with two parameters, one to filter the report by state and the other based on the sales amount like the following:

In order to resolve the fact that there is no option to select the logical operator between filters they must be combined into a single filter option.  This mean that the second filter will be removed and the OR statement will be placed into an expression in a single filter.  This same technique can be utilized on a data region as well within the report.  In the configuration of the filter we will set the expression like such:

And the Filters portion will look like the following now with the value being set to True and the expression type have a data type of Boolean.Now when we go and run the report the results contain not only the sales person from Minnesota, but also the other sales people that had sales of at least $1 million.

 

Comment Here

Comments

No Comments to Show

WE ALWAYS WORK WITH :