Why does my published report not show data from dot-walked fields?

[Steve Chapman]

Good day all,

My manager has tasked me with creating a report that a multitude of users can view generated mainly out of Change Request fields.

There is however 1 field (Business Service from the Impacted Services table) that is required to be in the report also.

Because I couldn't dot-walk to the business service field from the change request table, I dot-walked to all the change request fields from the Impacted Services table and in that report view all looks fine.

The problem I am having is that the data for the dot-walked fields disappears when the report is viewed via the published link, is this an inherent existing ServiceNow issue or is it pretty clear that I have done something wrong or not done something??

Many Thanks for any help as soon as is possible

Kind Regards

Steve

[Chuck Tomasi]

Can you include some screenshots? It would help identify the gaps between the admin and the non-admin user.

[Steve Chapman]

Sure, no problem.

What screenshots would you like me to include?

Ta

Steve

[Chuck Tomasi]

Show what is working (for admin) and what is not working for the non-admin so I can see what you are seeing. Right now I'm not sure what exactly isn't working.

Also, can you provide details on how you are publishing the report? Are you using this option in the report generator?

Are the users trying to access the report without logging in? If so, then you most likely have an ACL issue and need to open those dot-walked records up by adding the role "public" to the ACL.

[Steve Chapman]

Hi Chuck,

Yes that is the publish function I have used, yes non licensed users may access this and I have added "public" acl roles for the relevant fields, just not getting data in published report, see screenshot;

This is my view as an admin - the non-admin screen is the same with no data??

Thanks

Steve

[Chuck Tomasi]

Hi Steven,

You'll need to grant public to the table (change_request.none) and fields (change_request.*). Can you ensure both have been done?