Section Access issue

[alec1982]

Hi Guys,

I have set section access on one of the applications where the user will access the data based on the client Name.

When I relaod the document and then access the dashboard using one of the users I see the required client normallyand and the other client names are grayed out."Perfect!"

When I move to another sheet the Clear All trigger that I have set is effecting the client name and clearing that field out and the user sees all the other clients data.

Anybody knows how to fix it?

Thxs for all your help.

Alec

[alexpanjhc · Accepted solution]

in document property ->opening do you have initial data reduction based on section access checked and strick exclusion checked as well?

[Anonymous]

Make sure in 'initial data reduction based on section access' checked and 'strick exclusion' checked.

if there is no data, Section access fails to  join and it will show all other clients data.

so create a client id table within section application which has all client ids and it will work.