Testing Section Access

[#1]

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

[#2 · Accepted solution]

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

[#3]

Hi,  I have this working.

Is it possible to use 'Section Access' to show or hide Sheets depending on the user?

Thanks,

Fiorano

[#4]

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