I Guess the below syntax would help you.
STAR is *;
LOAD * INLINE [
ACCESS, NTNAME, REGION
ADMIN, ABC, , // user whoneeds to have admin access
ADMIN, BCD, , // user who needsto have admin access
ADMIN, CDE, , // user who needs to have adminaccess
ADMIN, DEF, , // user who needs to have adminaccess
'USER' as [ACCESS],
upper(trim([User ID])) as [NTNAME],
If(isnull(trim([REGION])) = 0, Upper([REGION]), ' ') as [REGION]
(ooxml, embedded labels, table is Authorization);
Set Application_Name = ABC Report';
Set Developer_Contact = 'abc';
Set Cargotec_Contact = 'abc';
Set Mail = 'email@example.com;
Set Phone = '+12345’;
Set ShortDescription ='xyz;
Note*: Please remember to select the option in Settings> Document Settings> check Initial Data reduction based on section access.
I have the same question: how can I split the access by several fields (for ex. REGION and CLIENT). Here (in Correct Answer) I see access split by REGION field only (one field). What is the way to make access to different users by different (several) fields?
For ex. I have to following table of regions/clients:
And I need to give the following access (for managers - on region level and for specialists - on client level):
User Region Client
ManagerA AAA *
SpecialistA1 AAA AAA1
SpecialistA2 AAA AAA2
ManagerB BBB *
SpecialistB1 BBB BBB1
SpecialistB2 BBB BBB2
SpecialistB3 BBB BBB3
ManagerC CCC *
SpecialistC1 CCC CCC1
SpecialistC2 CCC CCC2
SpecialistC3 CCC CCC3
SpecialistC4 CCC CCC4
Thanks for your help.
PS The table below is working (:)) but the need is not to copy each specialist's line to according manager but grant managers' access by region which includes according clients.
Message was edited by: romanergakov