Hide Fields in a Report View?

[Elizabeth26]

Is there an easy way to hide certain fields just within reports? We want users to be able to use/see fields in the table but not be able to select/view them in a report. 

[Elizabeth26]

I was not able to find a solution to prevent reporting against if the field is visible to the user on the table. If the user has access to the field to view they can report against. 

What I did instead was create a report to send out alerts when anyone used the field for reporting. Then we will contact them not to use it. Not ideal but it’s rarely used so not a big deal to do this. 

I wish I had found a better solution. 

[Shreya Wani]

Hi @Elizabeth26,

You can achieve this through report_view ACL.

The report_view operation is a record type access control list (ACL) that restricts access to reports. Only users who have one of the required roles can view reports that contain the restricted resource.

There are two kinds of report_view access control lists (ACLs):

1. report_view table ACLs

2. report_view field ACLs.

Report_view table ACLs prevent users from viewing report content based on the table specified in the ACL. Report_view field ACLs prevent users from viewing reports that use the field specified in the ACL in the group by, row, column or aggregation.

For ex., a report_view field ACL grants the report_admin role viewing access to the salary field in an HR table. When users with the itil or report_user role access a report grouped on the salary field, they see: Access to this content denied based on report_view field ACLs.

For more information, check out the below ServiceNow product docs.

https://docs.servicenow.com/en-US/bundle/utah-now-intelligence/page/use/reporting/concept/report-vie...

https://docs.servicenow.com/bundle/tokyo-now-intelligence/page/use/reporting/task/view-report-acls-l...

If you feel that I have assisted you in any way, please mark my comment as helpful.

Thanks,

Shreya