Dear Community
I have a requirement to show Full Company vs Division .
The problem I am facing is I have assigned Section Access on the Division field for some of users.
When a person opens Application, he only sees his Division Data, so how this is possible to show full company Data.
Is the below requirement possible when Section Access is Applied. Need Suggestions???
So for example If I have a particular expression I need to show their value and the overall value if that makes sense
=Num($(v%Assessed),'##%')
My section Access is below is working and just breaks each hospital in to it own display depending on who logs in.
How would I achieve the above?
My Section Access
Section Access;
AccessTable:
LOAD * INLINE [
ACCESS, NTNAME, HOSPITALID
ADMIN, HEALTHIRL\AA, *
USER, DSHDOM\BB, 3
ADMIN,HEALTHIRL\CC,*
ADMIN,ADMIN,*
USER, HEALTHIRL\DD,2
];
SecurityValues:
LOAD * INLINE [
Hospital, HOSPITALID
25, 25
20, 20
26, 26
6,6
16,16
22,22
5,5
9,9
4,4
27,27
23,23
14,14
15,15
28,28
10,10
17,17
11,11
3,3
2,2
1,1
8,8
7,7
12,12
13,13
18,18
19,19
21,21
24,24
];
concatenate(AccessTable)
load distinct HOSPITALID resident SecurityValues;
drop table SecurityValues;
Section Application;
star is *;
DataTable:
LOAD * INLINE [
HospitalID, HOSPITALID
25, 25
20, 20
26, 26
6,6
16,16
22,22
5,5
9,9
4,4
27,27
23,23
14,14
15,15
28,28
10,10
17,17
11,11
3,3
2,2
1,1
8,8
7,7
12,12
13,13
18,18
19,19
21,21
24,24
];
