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. 

[jMarshal]

ServiceNow recently (within the last year or 2) introduced "report_view" ACs exactly for this!

Report_view access control (servicenow.com)

[Elizabeth26]

I created an acl on a field for report_view and added admin as the only role to view that field for report_view.

However, when I used the user is still able to view the field in a report. 

[jMarshal]

Oh sorry, I misunderstood - report view exposes table data which is otherwise restricted, doesn't restrict report data which would be otherwise available...and in practice doesn't seem to work the other way, which is what you want.

You may be able to do this with a data transformation script. On the report, for the field in question, write a data transformation script that first checks the role and if it is the restricted role, the data transforms to "empty" and if not restricted, it just displays the actual value...?

I don't know a lot about the report you are referring to and this will definitely not work if further calculations on the report rely on the data in the field you are applying the role-based calculation/transform on.

In that circumstance, I think you need 2 reports for 2 separate audiences.

[damzelev]

I'm facing this same challenge, were you able to implement something?