Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we hide a column based on user Access/Windows AD?
For e.g: I have the below column. My section access will be on Cost Center field. Also, I would like to hide the column Salary where Salary Show = 1. So, only 'bbc' would see the salary details.
employee Name | Salary show | Salary | Cost Center |
aaa | 1 | 877 | 401 |
bbc | 0 | 455 | 501 |
ccc | 1 | 544 | 601 |
Any suggestions?
Thanks in advance.
If the Secction Access table is linked to the table you describe by the employee Name, when you access the application there should be just one [Salary show] value. For this to work the Secction Access table must have the [employee Name] field in order to link tables.
If that is so, then if salary is treated as a dimension, check the option to hide it on conditional when [Salary show]=0. If you are treating it as an expression, then show on conditional [Salary show] = 1 (on the expressions tab of the properties menú of the object).
In expression use conditional check box and test osuser() with the user you want to exclude
If you are using the section access, add the field name in the Hide condition on the presentation tab. This will automatically hide a chart when the user's Show Salary value = 0.
search for omit in the attachment
If the Secction Access table is linked to the table you describe by the employee Name, when you access the application there should be just one [Salary show] value. For this to work the Secction Access table must have the [employee Name] field in order to link tables.
If that is so, then if salary is treated as a dimension, check the option to hide it on conditional when [Salary show]=0. If you are treating it as an expression, then show on conditional [Salary show] = 1 (on the expressions tab of the properties menú of the object).
Thanks everyone. It worked. I used show condition in expression while using section access on Cost Center.