Reports automatically assume an "AND" statement between unlike filters (ex. Country and ProductName).

There are 2 different scenarios where Reports can apply OR's.

First Scenario:

1a. Using Unlike Field Names: You can use OR statements in filtering, first select a Filter Field such as "ProductName", then select an Operator such as "Equals" then type the names of the values to filter on in Value(s) using an OR statement separated by a comma, such as (ex. Widgets, Books, Bikes).

1b. Using Like Field Names: You want the "same" fields to equal different values for the filter, such as Field1 = A OR Field1 = B. 

2. The Operator "Use Previous OR" will apply the previous Operator to the Field selected.

Note: You can select the Sql icon in the Report Designer toolbar to view the sql code displaying the OR statement.

Second Scenario:

We want different fields to equal different/same values for our filter, such as Field1 = A OR Field2 = B

1. Create views in the database which will do this automatically. This is the simplest way to accomplish this and is recommended as a best practice.