Custom Report Filtering Problems
I have created a report to show all overdue cases and I have 2 questions on the filter options
1. to show to correct data, I set the filter with the sequence:
Request Status is "Open" OR Request Status is "Onhold" AND Overdue Status is "yes".
If I change the sequence to Overdue Status is "Yes" AND Request Status is "Open" OR Request Status is "Onhold", the result is difference and the data is wrong
2. I saved the report, and next time when I tried to run the report again, the filter option will automatically changed from
Request Status is "Open" OR Request Status is "Onhold" AND Overdue Status is "yes".
to
Request Status is "Open" AND Request Status is "Onhold" OR Overdue Status is "yes"
and then the report is wrong again...every time need to manual change the Match from AND to OR, OR to AND before running the report
1. to show to correct data, I set the filter with the sequence:
Request Status is "Open" OR Request Status is "Onhold" AND Overdue Status is "yes".
If I change the sequence to Overdue Status is "Yes" AND Request Status is "Open" OR Request Status is "Onhold", the result is difference and the data is wrong
2. I saved the report, and next time when I tried to run the report again, the filter option will automatically changed from
Request Status is "Open" OR Request Status is "Onhold" AND Overdue Status is "yes".
to
Request Status is "Open" AND Request Status is "Onhold" OR Overdue Status is "yes"
and then the report is wrong again...every time need to manual change the Match from AND to OR, OR to AND before running the report