Weird Report Filter Error
Please see the following screen capture, but when we filter a report by columns some of the rows disappear.
https://www.screencast.com/t/Sx94peSOpT
Any ideas?
Thanks, Tevis
Asked by Tevis Boulware
on Wed 5/4/22 7:11 PM
Sign In to leave feedback or contribute an answer
Answer (1)
This answer has been marked as the accepted answer
Mark Sayers
Thu 5/5/22 10:28 AM
Hello Tevis,
Can you share the details of this report? I'll need to see how it is being filtered to have a better idea of what might be going on.
No feedback
All the correct records are displayed initially, but the "Wait For Customer" records disappear when ordering using the tabs, but the record count stays the same.
Here are the details:
Columns & Filters
Reported Columns
ID
Title
Status
Requestor
Acct/Dept
Prim Resp
Modified
Column Ordering
Modified - Descending
Applied Filters
Resp Group is one of [USS-Academic North Students]
Status is one of [New, In Process, Waiting for Customer, Scheduled, On Hold] - Tevis Boulware Thu 5/5/22 12:06 PM
Here are the details:
Columns & Filters
Reported Columns
ID
Title
Status
Requestor
Acct/Dept
Prim Resp
Modified
Column Ordering
Modified - Descending
Applied Filters
Resp Group is one of [USS-Academic North Students]
Status is one of [New, In Process, Waiting for Customer, Scheduled, On Hold] - Tevis Boulware Thu 5/5/22 12:06 PM
That definitely is interesting behavior. I wonder, if you change that responsible filter instead to be Prim Resp is a member of [USS-Academic North Students], does that make a difference in the results returned for this report?
Also, check out the report's Edit screen and see how many rows are specified in the Max Rows field? - Mark Sayers Thu 5/5/22 1:20 PM
Also, check out the report's Edit screen and see how many rows are specified in the Max Rows field? - Mark Sayers Thu 5/5/22 1:20 PM