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

try this

SECTION Access;

LOAD * INLINE [

    Access, userid, password

    user1, test1, pass1

    user2, test2, pass2

    user3, test3, pass3

];

SECTION Application;

[#3]

Hi Vishwaranjan,

I tried this, but then it shows the login screen.

I want users to login once only in accesspoint and then use this user further in the reports wherever required.

[sujeetsingh]

Hi,

SECTION Access;

LOAD * INLINE [

    Access, userid, password,Branch

    user1, test1, pass1,B1

    user2, test2, pass2,B2

    user3, test3, pass3,B3

];

SECTION Application;

And then go to setting <<<Document Properties .<<<<opening<<<<<Check initial reduction ...

[#5]

Hello,

I found the solution.

In the above code, I used OSUser.

Now it does not show the login screen, but shows the respective branch.

Thanks to both of you.

[sujeetsingh]

You are welcome!!!!

[#7]

Hi Apurva,

Could you please attach you qvw file for reference?

Thanks,

Anju

[khadeer]

Hi following code solve ur issue .....

and check document properties.....Opening tab..... Initial data reduction based on section access.

SECTION Access;

LOAD * INLINE [

    Access, userid, password

    user1, test1, pass1

    user2, test2, pass2

    user3, test3, pass3

];

SECTION Application;

LOAD * INLINE [

    userid, region

   test1, 'Delhi'

  test2, 'Mumbai'

test3, 'Pune'

];

[#9]

Anju,

I cannot upload my file, as I have all the client data.

But the code given by others in this discussion works.

If you want to know anything else, please let me know.

[#10]

Hi Apurva,

Is it possible to paste the code with function OSUser ?

Thanks,

Anju