section access

[#1]

Hi Guys,

Please help me out of this problem:

I have 2 users  1- admin   pass : admin

                      2- user      pass : user  

I want admin sees every things and users sees just one regional manager from the report.

Thanks,

[pover · Accepted solution]

Columns that link section access with the data model have to be in uppercase letters.  The following script worked for me.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, REGIONAL_MANAGER

    ADMIN, ADMIN, ADMIN, *

    USER, USER, USER, 'SAM, KON'

];

Section Application;

LOAD upper(REGIONAL_MANAGER) as REGIONAL_MANAGER,

     SALES

FROM

[Classeur1.xls]

(biff, embedded labels, table is Feuil1$);

Karl

[#3]

Thanks karl,

It worked with user name now, you were right.

Could you please give me a hint to change it to NTNAME.

I tried and it did not work.

Thaks,

Nima

[pover]

Nima,

Replace the USERID and PASSWORD columns with NTNAME.  Make sure NTNAME includes the domain and the user.  For example, QVDOMAIN\KARLPOVER.  You have to be logged on as that user in your computer or accesspoint for this to work.

Karl