Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using NT security for Section Access and need to set up a conditional show expression to only show the "Details" sheet if "LEVEL" = "DETAIL".
See my section access code below:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, LEVEL
USER, iwavetwo\jrush, DETAIL
USER, iwavetwo\dstein,
ADMIN, iwavetwo\bash, DETAIL
];
Section Application;
Does anyone know how to make this happen?
Yigal BO wrote:
Hi,
Try This:
SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID, LEVEL
USER, 1, DETAIL
USER, 2,NO_DETAIL
ADMIN, 3, DETAIL
];
Section Application;
LOAD * INLINE [
LEVEL,VALID
DETAIL, 1
NO_DETAIL,0
];
And then in the Conditional Show: sum(VALID)>0
See the attach example.
Hope it help.
Thanks for your reply, Yigal BO.
This is the correct approach, but I found out it does not work until you turn on the check box, "Initial Data Reduction using Section Access." It worked for me after checking that box. Also, I turned Strict Exclusion on.
Hi,
Try This:
SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID, LEVEL
USER, 1, DETAIL
USER, 2,NO_DETAIL
ADMIN, 3, DETAIL
];
Section Application;
LOAD * INLINE [
LEVEL,VALID
DETAIL, 1
NO_DETAIL,0
];
And then in the Conditional Show: sum(VALID)>0
See the attach example.
Hope it help.
Yigal BO wrote:
Hi,
Try This:
SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID, LEVEL
USER, 1, DETAIL
USER, 2,NO_DETAIL
ADMIN, 3, DETAIL
];
Section Application;
LOAD * INLINE [
LEVEL,VALID
DETAIL, 1
NO_DETAIL,0
];
And then in the Conditional Show: sum(VALID)>0
See the attach example.
Hope it help.
Thanks for your reply, Yigal BO.
This is the correct approach, but I found out it does not work until you turn on the check box, "Initial Data Reduction using Section Access." It worked for me after checking that box. Also, I turned Strict Exclusion on.
Hi brandoncash,
If i have less than 10 user it is fine.
suppose i have 1000 users, then what will we do...
Thanks.........