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]

Is this all users or some? If some, then have you checked ACLs to ensure that users have the ability to read records from the dot-walked tables?

Docs: Access control rules

Docs: Contextual security  

Security Best Practices - ServiceNow Wiki

[Steve Chapman]

Hi Chuck, Many thanks for your very prompt reply.

The report appears to be restricted to any user that isn't an admin (so pretty much everyone) but the report itself is to be publicly viewable and the ACL's have been created to reflect this. . . . . Unless this is where I have made an error??

Regards

Steve

[Chuck Tomasi]

Hi Steven,

Can you provide some clarification... When you say that you published the report, are you using the public URL?

[Steve Chapman]

Yes Chuck,

I have created the report, published it and used a non-admin user to check the URL generates report as expected, which it does not.

Thanks

Steve