Custom report not appearing under 'View / Run'

[therese_erickso]

Hi,

We have created a custom report that is not showing under Reports --> View / Run   but is accessible via Administration --> All.

I have tried playing around with the roles (including removing them entirely) but to no avail. Can anybody point out what I am missing here? Thanks in advance.

[Ryan Gladwyn-Na]

For us, it appears as if the reference to the database view table is corrupted when migrating the changes using an Update Set. In our development instance, for reporting, the database view table appears in the list of available tables using the format 'Label [u_name]', but after migration, appears as 'u_name [u_name]'. Our workaround is to manually recreate the database view, report source, and reports in Production.

[Viengthong Lua1]

Hi Tess,

Please find below a copy/paste from an article found on the Internet:

"After FUJI upgrade you may discover that Reports shared by your users with groups and other users suddenly become not available to those with whom they had shared them.

The issue is coming from a Read ACL over sys_report table which should check report availability for Groups and Users using sys_report_users_groups table. But it checks the security using legacy fields located in sys_report record itself.

To fix the issue simply activate the plug-in com.glideapp.report_security (aka "Report Security — enforce access control checks"). It updates the Read ACL over sys_report.

Important to mention that this plug-in is already activated in new servicenow instances but in old instances upgrading to FUJI it is NOT activated by default.

Hope this helps to upgrade your instances smoothly to Fuji!"

Regards,

Viengthong

[therese_erickso]

Thanks Viengthong.

The Report Security plug-in is already activated in our instances so unfortunately this is not the issue we are having.

[Ryan Gladwyn-Na]

Received workaround from SN - This is a known issue resolved in Fuji Patch 6 - PRB631892: A report that is reporting on a table/view that does not have sys_documentation entry for the table will not show on report_home.do

1. Login to your instance, type: sys_documentation.list on left hand panel

2. Click on New button to create a new Field Labels record.

3. Enter Table, Label and Plural and click Save.

4. Go back to Reports > View/Run, and the reports should now be visible.

[Uncle Rob]

Careful with Fuji Patch 6, especially if you've got any usage of Stage column in presentation of Request Item list views.   There's an undocumented change to the Stage rendering.   It gets *REAL* ugly if it doesn't feel Stage field is wide enough.     Looks a little something like this.

Not scheduled to be fixed until Fuji Patch 8