Report Builder Filter Breaks When Removing/Adding Fields

  • 6
  • Problem
  • Updated 5 months ago
  • Acknowledged
I am having the problem of when I am building reports and i remove or add fields and click run it changes whatever complicated filter i had ie A AND  B AND (C OR D OR E OR F) AND G to all ANDS and it breaks the report showing no data. It happens often, I have to copy the filter and paste it back in and even when I do that it gives a weird invalid expression message at saving at first then I click save and it allows me to run it then.
Photo of Brandy Guillory

Brandy Guillory

  • 788 Points 500 badge 2x thumb

Posted 1 year ago

  • 6
Photo of Heather Hansen

Heather Hansen, Champion

  • 9,192 Points 5k badge 2x thumb
Agreed!  This drives me crazy.  Especially painful for reports that have a lot of filters.
Photo of Heather Landgraf

Heather Landgraf

  • 1,174 Points 1k badge 2x thumb
DRIVES ME NUTS!  when I add a filter and my filter logic disappears and it can take a bit to get it back to what it was.  Really painful when you have a bunch of filters and the logic is a bit crazy.  Once wrong thing and your data is bad.  Please fix this!