How to hide the margin, and revenue columns from a particular user in the CustomerItemStatistics ssrs report?

ahmed_fathey · August 15, 2016, 1:11pm

CFO has requested to hide the following columns from the report ‘CustomerItemStatistics’ from the salesPersons:

Revenue

Margin

I have tried to duplicate the report and to add a new menu item for the new report, but I failed to create a working duplicated report.

I wonder if someone could help…

MartinDrab · August 15, 2016, 4:35pm

What’s the version of AX? You haven’t attach any tag with the version.

Nevertheless you surely don’t have to copy the whole report to change the visibility of two columns.

ahmed_fathey · August 15, 2016, 4:59pm

Current version is 2012 R3
What is really requested is to hide these two coloumns from whoever has the role ‘x’

MartinDrab · August 16, 2016, 8:02am

Then you need to configure permissions for the security role and not changing code.

TulayYENER · August 16, 2016, 8:09am

Hi ahmed_fathey,

This link helped me before.