Macro in the Report studio

[ravitej]

The user name is "Scott" his group is "HR".

I have to restrict this user on Salary column. Could you please let me know how to restrict for this user?

So that I can implement the other users too.

This is great help from your side


If (#sq(CSVIdentityNameList())# contains 'Group Name')
then ([Salary])
else (0)

[kattaviz]

Hi.
Try this

CASE
WHEN 'HR' IN (#CSVIdentityNameList()#)
THEN 'null'
ELSE ([Salary])
END
This has to be implemented in FM for the column.

HTH

[cognostechie]

I am not sure the 'in' operator will work in this case.
Moreover, this can be used in Report Studio too without doing it in FM.