Reports - Case table field wont populate

jabaya
Mega Guru

Hello I hope you’re having a good day. I’m reaching out for assistance with a report I’ve created on the time_card table. I’ve applied some filters to this report, but I’m encountering an issue. Specifically, I’m trying to display the value of the "Case Total Time Approved" field from the case table in the report. Oddly, while the "Total Time Worked" field from the same case table is displaying correctly, the "Case Total Time Approved" field is not showing any value. Both fields are visible on the form and in the list view.

jabaya_1-1726568624666.jpeg


jabaya_2-1726568645538.jpeg

 

 

This is the report view.

 

 

 

jabaya_3-1726568678479.jpeg

 

jabaya_4-1726568837568.png

  


I have checked ACL and any BR, Script include that might be associated but no luck at all.



Please see screenshots for reference

1 ACCEPTED SOLUTION

jabaya
Mega Guru

Just to update and found the reason. reports dont accept dot walking to another table.

we've concluded that we hit a Limitation in development of reports with regards to a field that is not supported for dot walking, as per documentation " Function fields in reporting do not support dot walking. "
which is the case of "Case total Time approved" field that exist in case table that's why its blank/not displaying any value even if its visible in list and form
level.

Please see this servicenow documentation for reference;
( https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/reporting/task/configure-f... )

Perhaps we we're able to produce the results we want by doing database view. where the two tables will be combined.

View solution in original post

3 REPLIES 3

Gangadhar Ravi
Giga Sage
Giga Sage

@jabaya Please check if there is any report view ACL's for those fields.

 

Please mark my answer correct and helpful if this works for you.

Hello thanks for response, i did check ACL's already but nothing anything related to report view ACL's for this fields.

jabaya
Mega Guru

Just to update and found the reason. reports dont accept dot walking to another table.

we've concluded that we hit a Limitation in development of reports with regards to a field that is not supported for dot walking, as per documentation " Function fields in reporting do not support dot walking. "
which is the case of "Case total Time approved" field that exist in case table that's why its blank/not displaying any value even if its visible in list and form
level.

Please see this servicenow documentation for reference;
( https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/reporting/task/configure-f... )

Perhaps we we're able to produce the results we want by doing database view. where the two tables will be combined.