Forum Discussion

RobinWiggins's avatar
RobinWiggins
Qrew Trainee
6 years ago

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!

  • 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.
    • RobinWiggins's avatar
      RobinWiggins
      Qrew Trainee
      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.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      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.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      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?
  • 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.
    • RobinWiggins's avatar
      RobinWiggins
      Qrew Trainee
      I'm really asking if/how the AND can be changed to an OR.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      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.