Is it possible to create a report that uses a mixture of AND and OR operators using the AND and OR radio buttons in the Create New Report wizard?

0 Likes

Problem:

Is it possible to create a report that uses a mixture of AND and OR operators using the AND and OR radio buttons in the Create New Report wizard?

Resolution:

ANSWER
----------------------------------
This is not currently possible using the AND and OR radio buttons. When the AND radio button is selected then all selection criteria use the AND operator. Similarly, when the OR radio button is selected then all selection criteria use the OR operator. It is possible to modify the operators connecting the selection criteria in SQL via the Advanced Query option.

Old KB# 23699
Comment List
Related
Recommended