How to remove second filter on drilldown report?

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
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!

Photo of Robin Wiggins

Robin Wiggins

  • 120 Points 100 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Are you very sure that your drill down report which is set for the summary report does not have any filters? It’s supposed to be an unfiltered report.
Photo of Robin Wiggins

Robin Wiggins

  • 120 Points 100 badge 2x thumb
Yes, I just double-checked and it does not have an initial filter.
And I get the same issue with no initial and no dynamic filter.
When you said this 

"an initial filter", did you mean the drill down report?  I was asking about the drill down report used by the Summary Report.
ie on the drill down report that you have set the summary report to use, if you review that report on a stand alone basis, is it unfilered?
Photo of Robin Wiggins

Robin Wiggins

  • 120 Points 100 badge 2x thumb
Yes, I also mean on the drilldown report.
I used the word "initial" because that's the term I'm seeing when I go in to customize the report. There are initial filter and dynamic filter options.
I think that I did not really understand your question.

Are you saying that you start with a summary report and then type something into the search filter to get a reduced summary report and then you drill down, and your issue is that it is apply that search term to your results?

If so, of course that would be the expected behaviour.
Photo of Robin Wiggins

Robin Wiggins

  • 120 Points 100 badge 2x thumb
I'm really asking if/how the AND can be changed to an OR.
(Edited)
No it can't.  If you want to have an OR you can set up and <ask the user> filter on Summary report.

But also note that you may not know that if you enter a search term such as cats OR dogs, with the OR in upper case, then it will behave as an OR.

You can also use AND, and again it must be in upper case.

Maybe that tip helps in some way.