Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
Im trying to set up Section Access in my QV document. Is it possible to test if I have Data Reduction Working even if I am ADMIN?
In need the Data Reduction to work from the NTNAME of the user eg; DOMAIN\LoginID.
Any help appreciated
Fiorano
Hi,
yes you can test Data Reduction even if your are Admin.
You should have something like this in your script :
SECTION ACCESS;
LOAD NTNAME,
ACCESS ,
FIELD_X,
FIELD_Y
FROM
[..\XLS\Section_Access.xlsx]
(ooxml, embedded labels, table is SA);
SECTION APPLICATION;
--Your Data
you have to Enable Section Access on document level:
Tick the option “Initial Data Reduction Based on Section Access” on “Settings” -> “Document Properties” -> “Opening”
Recommendations :
Backup your applications before implementing Section Access.
Work in multiple copies so that you can step back if you "lock" yourself out.
Use only UPPER CASE names for section access fields
Hi,
yes you can test Data Reduction even if your are Admin.
You should have something like this in your script :
SECTION ACCESS;
LOAD NTNAME,
ACCESS ,
FIELD_X,
FIELD_Y
FROM
[..\XLS\Section_Access.xlsx]
(ooxml, embedded labels, table is SA);
SECTION APPLICATION;
--Your Data
you have to Enable Section Access on document level:
Tick the option “Initial Data Reduction Based on Section Access” on “Settings” -> “Document Properties” -> “Opening”
Recommendations :
Backup your applications before implementing Section Access.
Work in multiple copies so that you can step back if you "lock" yourself out.
Use only UPPER CASE names for section access fields
Hi, I have this working.
Is it possible to use 'Section Access' to show or hide Sheets depending on the user?
Thanks,
Fiorano
Yes.
Try this :
SECTION ACCESS;
LOAD NTNAME,
ACCESS ,
FIELD_X,
ACCESS_SHEETX -- 1 or 0
FROM
[..\XLS\Section_Access.xlsx]
(ooxml, embedded labels, table is SA);
SECTION APPLICATION;
--Your Data
LOAD * INLINE [
ACCESS_SHEETX
1
0
];
On Conditional Show Sheet of sheet properties , add : only(ACCESS_SHEETX) = 1