availability of illicit values (Section access)

[#1]

Hello

I want to limit the visibility of sales channels, only channel with ID 6886711.

here's a code:

Section Access;

LOAD *

FROM

[..\Works\Access.xls]

(biff, embedded labels, table is [Access$]);

Section Application;

CHS:

LOAD CHANNEL_SALE_ID,

     CHANNEL_SALE

FROM

[..\Works\CHANELS.xls]

(biff, embedded labels, table is [Sheet1$]);

here is my Access.xls:

here is my CHANELS.XLS

When I open 33.qvw , I can see the filter under the terms of the "Section Access", everything is fine ...

but... WHY user "trish" can remove this limitation and to view the entire list of values​​?

[swuehl · Accepted solution]

You are using option 'Initial selection' on Opening tab of document properties.

If you want to limit the data available to that user, you'll need to use option 'Initial data reduction'

Introduction to Section Access