Reporting - hiding a field

[kbean1]

Hi Everyone,

Does anyone know if it is possible to keep a field from being reported on?   In my example, there is sensitive data being kept in the description field for a particular table (hr_case), and we don't want the description field to be available on list of fields for selection.   We want to prevent anyone from accidentally adding description as a field to a report.

Many thanks,

Ken

[Pradeep Sharma · Accepted solution]

Hello Ken,

Read ACLs are the only way to limit field selection from reports. If the user cannot read the field for ANY of the records in the table, the field selection will be removed.

[kbean1]

Hi Pradeep,

This is what I was afraid of.   I created a read ACL with "nobody" as the required role.   This removes it from the reporting list, but also removes the ability for users to update and read the field during normal operations.   Because users will still need access to the field, the existing read ACLs on the field will grant permission and always override the ACL that denies access.   It seems you can't just remove a field from the reporting selection without removing it from other parts of ServiceNow.

Cheers,

Ken

[Harsh Vardhan]

Hi Ken,

Please check the thread below.

How to completely hide a table column?

[Karthik Reddy T]

Hello Ken,

Write a   field (on description filed) level ACL   and verify report then that field can't be available in the selection.

http://wiki.servicenow.com/index.php?title=Using_Access_Control_Rules#Field_ACL_Rules&gsc.tab=0