Published Report showing error No Data to Display even for itil group

kmoussa · ‎12-20-2017

HI, I've come across an issue where one of my users who has ITIL and report_group roles has published a report and shared it with a named group as well as put them in the user's slush bucket. She says that when they click on the link they only see the report headings and not the pie graph. If they use the URL for the report in SNOW it works, just not the published link. The error is No Data to Display Is this related to ACL issues? I am very new and my developer is away so I am not sure how to check. Thanks in advance.

Adam Stout · ‎12-21-2017

Publishing a report exposes the report to users not logged into the instance. However, if there are ACLs, they are still enforced. If the report shows data from tables that are secured with ACLs, you could end up with this result. If you remove the ACLs, be sure you are OK with everyone with the link being able to see that data even if you do not know who they are.

View solution in original post

Adam Stout · ‎12-21-2017

It depends on your needs, your environment, and the type of report. ACLs won't stop you from displaying aggregates but they will prevent list views from showing and they will prevent users from clicking on the details and seeing the list view.

Anonymous users get you into trouble if you have any before query rules on the table. I'm not actually what is causing your issue, but these are some things to look at.

Sharique Azim · ‎06-11-2018

Hi,

Isnt it strange that this issue is only observed by me after the kingston upgrade?

Adam Stout · ‎06-11-2018

It depends on what you upgraded from. For any upgrade, there are changes (including fixing previous issues). I would be more concerned if it just stopped working.

kmoussa · ‎12-21-2017

kmoussa · ‎01-14-2018

Figured out what the issue was. My Developer said that the report was being published to non-ITIL users and that was the problem. The fix could be to change security settings to allow the report to be published to outside users' but we don't want to do that as it is a high risk. A better option is to have them purchase a fulfiller license. Thanks for all your input.