Hide OMITed fields

[#1]

Hi, is there a way to hide fields that certain users are not allowed (OMIT in Section Access) to see?

As it is now I have:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, OMIT

    ADMIN, ADMIN, ADMIN,

    USER, SCM, SCM, test

    USER, PM1, PM1, test

];

Section Application;

where 'test' is the field I want to hide for users SCM and PM1.

Now the users can see the field which is (unavailable). Can I simply hide unavailable fields?

Any other tips & tricks regarding design of reports with limited access rights?

Thanks.

/Mikael

[jvitantonio · Accepted solution]

Hi,

You can use the function QVUser() and then play with the conditional show. for instance, if the object you want to hide is a list box, go to the list box properties -->LAyout --> Show on Conditional and put:

=If(QVUser() = 'SCM' or QVUser() = 'PM1', 0,1)

I hope this helps.