section access

[#1]

Hello,

I have users from different branches.

As user opens the report he should be able to see data only of respective branche only.

So how to accomplish it?

[#2]

As per my script, it will verify the OSUser.

Branch is the field for which I want to do the section access.

You dont have users test1 or test2, still your document is opening. I am also not aware why it is hapening so, as I am also learning how to use section access.

[#3]

Thanks a lot, Apurva..

One more thing...are B1 and B2 two different sheets of the same .qvw document?

[#4]

Hi Khadeer,

SECTION Access;

LOAD * INLINE [

    Access, userid, password

    user1, test1, pass1

    user2, test2, pass2

    user3, test3, pass3

];

SECTION Application;

I tried this, but , I am not able to pass the login screen where I am prompted for UserId..Kindly reply.

Thanks,

Anju

[#5]

No.

B1 and B2 are not the sheets. but data in Branch field.

[#6]

Alright! Thank You..

[#7]

Hi,

Please can anyone help me on this issue.

[khadeer]

Hi Apurva,

Check attached example its working fine for me..... to open that file....

userid: ADMIN

password: ADMIN

userid: USER1

password: USER1.

check the script. Let me know if any issues..

Anju,

To get login screen u have to check the option in document properties .... opening tab.... initial data reduction based on section access

[#9]

Hi Khadeer,

But I do not want to get the login screen.

Instead, I want to use the OS User.

[khadeer]

Hi,

Then keep only OSUSER..... dontkeep password.... And do same procedure..

[Jason_Michaelides]

Try using NTNAME instead of OSUSER.