Issue with Custom Report (filter by Ref. Ticket Number)

Issue with Custom Report (filter by Ref. Ticket Number)

Hello,

I ran into an issue while creating a Custom Report for tickets that:

1) Were created this year (works fine)

2) Ref. Ticket Number field is not empty

I selected the Advance Filter - Ref.Ticket Number 'is not' None

The report runs correctly for the first two to three pages but I see a lot of 'Not Assigned' (basically blank field) starting page four.

I also did an export to CSV to filter 'Not Assigned' tickets and got the result:

Out of 1387 tickets that showed on the report, 1150 odd were 'Not Assigned'. Please investigate and let me know how I could pull a clean report for tickets in which Ref. Ticket Number field is populated.

Thanks in advance!

Nikhil

                  New to ADSelfService Plus?