| :: Filtering Conditions some filters not shown :: (1) | Post a New Message | Post a Reply |
 Filtering Conditions some filters not shown | Post a Reply |
from: Tampa, FL
I have two reports that access the same table and when setting a filter on a specific column I get different filter conditions in the pull down menu in the two reports.
One report pull down menu has the following options in the Condition pull down menu (contains, does not contain, is equal to, is not equal to, is less than, is greater than, is less than or equal to, is gretaer than or equal to, starts with, ends with).
The second report contians all the above in the Condition pull down menu plus the following (is empty, is not empty, IS NULL, IS NOT NULL, IS MAX, IS MIN, is below average, is above average, IS IN (e.g. 1,2,'A','B')).
Questions:
1.) Why would options in the Condition pull down menu be different in the two reports?
2.) Why would options in the Condition pull down menu be different in two reports accessing the same table when filtering on the same column?
Thanks