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]

Hi Anju,

Section Access;

LOAD * INLINE [

    ACCESS, OSUser, BRANCH

    ADMIN, test1, B1

    ADMIN, test2, B2

];

Section Application;

And then go to setting <<<Document Properties .<<<<opening<<<<<Check initial data reduction based on section access and strict exclusion.

I am also testing it for different scenarios. Need to check if it works for all.

[#3]

Hi,

I tried following code and it is not working.

Section Access;

LOAD * INLINE [

    ACCESS, OSUser, BRANCH

    USER, test1, B1

    USER, test2, B2

];

Section Application;

If I use ADMIN in ACCESS, then it will work.

but when I use USER in ACCESS, then it is not working.

[#4]

Thank you!

[#5]

Hi Khadeer,

if I use ADMIN in ACCESS column, reload and I re-open report, it will show data as per the branch mentioned for the user in section access.

But when I use USER in ACCESS colu, reload and I re-open report, it shows all the data.

what I am doing wrong?

[#6]

Please can any one help me on this?

[khadeer]

Hi Apurva,

I hope u r text is not matching with given text in section access. Please check that it works fine for me..

Suppose for user region 'Delhi' check as exactly in values in the table... it may b because of spaces n other.

Hope it helps u...

[#8]

Hi Khadeer,

Section Access;

LOAD * INLINE [

    ACCESS, OSUser, BRANCH

    ADMIN, usr1, B1

    ADMIN, usr1, B2

    ADMIN, usr1, B3

    ADMIN, usr1, B4

    ADMIN, usr1, B5

    ADMIN, usr1, B6

    USER, usr2, B1

];

Section Application;

LOAD * INLINE [

    USERID, BRANCH

     usr1, B1

     usr1, B2

     usr1, B3

     usr1, B4

     usr1, B5

     usr1, B6

     usr2, B1

];

Above is my code.

But it is not working as expected.

for Usr1 it shows all the branches.

for usr2 it should show only branch1 but it is showing all the branches.

[#9]

Hi ,

Section Access;

LOAD * INLINE [

    ACCESS, OSUser, BRANCH

    ADMIN, test1, B1

    ADMIN, test2, B2

];

Section Application;

It is not working for both 'ADMIN' and 'USER'. The prompt itself is not appearing.

[#10]

Hi anjugopinath,

if you want the login window to display then you need to use the

script given by Khadeer.

I didnot want to show the login screen, but directly use the OSUser,

so my script will not show the login prompt.

[#11]

How does it verify the user then? I don't have any user named 'test1' or 'test2'. But, the document still opens.

And what is branch?