Report Variables not working properly

Hello,

I have the following report parameters setup however, they are not working properly:

WHERE WhsCode = '[%0]' OR '[%0]' = ' '
AND ItemCode = '[%1]' or '[%1]' = ' '

What I want to be able to do is either

1. Run report for specific warehouse and no item code so it pulls in all items in one warehouse

2.Run report 'blank' for no warehouse and no item code for all items in all warehouses

3. Run report for a specific warehouse and leave the item code blank so it pulls in all items

4. Run report for a specific warehouse and a specific item

Here is what is happen currently:

1. If I run for a specific warehouse it pulls in the following data ( Ran for Rework):

2. It works when I run for a specific item:

3. If I run for a specific item and warehouse, it does not pull in the proper data. It pulls in all items for that warehouse:

Comments