- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content
Allow No or Multiple Values for All Filter Operators

In the old reporting tool there was an option to have 0 or more values per filter and each one would be evaluated based on the filter Operator. This was critical to our business process as each user running a given report has different requirements for what they need in the results. Some users would require the report to provide all data from the system, and some would require anywhere from 1 - 100 filter values. In the new reporting tool the only way to have multiple values per filter is to use the "In" operator which requires an exact match, and if there is a filter a value must be entered to return results. This is a problem when the full value is unknown or if there are no filter values needed.
eg.
If I have 30 accounts which have variations of the same account name "Spam Eggs and Spam" and another 30 with variations of "Meridian Memories Photography." If I want to pull back all accounts which have "Eggs" or "Memories" in their names I would need to use the "Contains" filter on these words.In the current reporting tool I would be able to add both of these as Filter Values at Run-Time and would get a single report containing all 60 accounts. However since the new reporting tool only allows a single value to be used for the "Contains" operator, these would need to be run as separate reports. Alternately if I wanted to use this same report and return All accounts in the system, I would have no way to do so since if the filter is left blank the report will not return any results and there is no way to omit a filter at Run-Time.
Since there is no way to know in advance how many filter values need to be added (or if they are needed at all), we need the ability to either leave the value blank or have multiple values for a filter regardless of the operator type or filter key.
- Find more ideas tagged with:
- Report Filter
- reporting
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.