Forum Discussion

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