why there is a discrepancy in schedule report --for particular field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023 07:15 AM
Hi all,
There is a schedule report created which generates report daily..but suddenly we are seeing a data discrepancy for a particular field. The specific field called " suspended" which is choice type..in the scheduled reports this field is showing data discrepency but If I export it manually it is giving me correct data.
Any reason for this behaviour
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023 07:28 AM
what's the discrepancy?
what is the expected outcome and what's the actual come?
Is it happening with only this choice field?
what about other choice fields?
Was this working fine earlier?
Did you upgrade recently?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2023 12:49 AM
what's the discrepancy?
For a particular customized choice type field we are seeing this discrepancy..In the schedule report it is showing empty for that field but in the actual case it has a value.
what is the expected outcome and what's the actual come?
Expected outcome should be whatever the value selected for that particular choice field but it is showing empty
Is it happening with only this choice field? YES
what about other choice fields? Other choice fields are fine
Was this working fine earlier? yes (Point to highlight the user who created this scheduled report is not an active user currently in the system.
Did you upgrade recently? No