Need help on Section Access

[avinashelite]

Hi Friends,

Requirement: We have employee ID's and their Managers ID's, when the Manager login he should see that data related to him and his reporting employees but when Employee login he should see only his details.

To achieve this I am using section access and Hierarchybelongsto  function in script but not able to get the result.

Please see the attachment for Data and qvw file.

Give USERID as 1 or 2 or 3 or 4.

[Anonymous]

hi

see my post for a possible soution

Best

Stefan

[avinashelite]

Hi Stefan,

Thanks a lot for your time, but my requirement is different!! based on the login i need to reduce the data.

[tresesco · Accepted solution]

In that case, try:

SECTION Access;

LOAD Upper(ACCESS) as ACCESS,

    USERID,

    Upper(USERID) as PERMISSION

PFA

[Anonymous]

Hi,

i didn't apply section access, did only the table structure. see this qvw for applied sa.

Best

Stefan

[avinashelite]

thanks a lot tresesco it works fine..Thanks a lot for your valuable time

[avinashelite]

Hi Stefan Kunte

This works too..Thanks a lot for your help