RobinWiggins
6 years agoQrew Trainee
How to remove second filter on drilldown report?
I have a summary report that provides a list for users to choose a Franchise to display the Specs related to that franchise.
The issue I'm having is when a user chooses a franchise, the drilldown report sometimes displays no results because the filters applied by default are for the chosen franchise to be in the Franchise field "AND Some field contains" (from the global search).
In the example, I entered the search word 'delete' in the parent summary report because I knew it would bring up the Franchises we marked "_ to delete", and then I would be able to chose that franchise to see the items. In the drilldown report I am forced to accept the additional 'AND Some field contains' filter:
There are no initial filters placed on either the parent or the drilldown report.
I understand the first filter is here because I chose the Franchise from the summary report list - this makes sense that it is filtering for these results.
What I need to know is how to remove the "AND Some field contains" part of this filter.
It must be coming from that first global search field that I used to narrow the list of hundreds of franchises, but at this point I can choose my franchise group, and if that must remain in the filters after the selection is chosen, why is it an AND instead of an OR?
Thanks for your help!
The issue I'm having is when a user chooses a franchise, the drilldown report sometimes displays no results because the filters applied by default are for the chosen franchise to be in the Franchise field "AND Some field contains" (from the global search).
In the example, I entered the search word 'delete' in the parent summary report because I knew it would bring up the Franchises we marked "_ to delete", and then I would be able to chose that franchise to see the items. In the drilldown report I am forced to accept the additional 'AND Some field contains' filter:
There are no initial filters placed on either the parent or the drilldown report.
I understand the first filter is here because I chose the Franchise from the summary report list - this makes sense that it is filtering for these results.
What I need to know is how to remove the "AND Some field contains" part of this filter.
It must be coming from that first global search field that I used to narrow the list of hundreds of franchises, but at this point I can choose my franchise group, and if that must remain in the filters after the selection is chosen, why is it an AND instead of an OR?
Thanks for your help!