What type of report is it? Can you post a screenshot of how the report is configured?
Advanced filter in report
I need to filter data using an advanced filter like "3 and 4 and ((1 and 2) or 5)"
The problem is that some rows are duplicated (even appear 4 times) depending which part of the filter bring them.
It looks like if the OR filter adds the rows and doesn't insert an OR condition in the filter as expected.
Is there a way to avoid duplicated rows ?
Please sign in to leave a comment.
Here is a screenshot of the filters I 'd like to use. I had no duplicated row since the filterwas only build with criteria 1 to 4 without advanced logic (1 and 2 and 3 and 4).
I would need to see the rest of the report configuration as well, not just the filter window.
Can you also try changing the criteria to:
(1 AND 2 AND 3 AND 4) OR (3 AND 4 AND 5)
I tested the option you suggested but still have the same results with dupliacted rows (4 times each).
Thez name of the report is "Envoi formulaires NPS déploiement". Can you access it ?