Section Access at Data level(for rows and columns)?

[saumyashah90]

Suppose i have Data's for different department for example

Header 1	Header 2
DEPARTMENT	DATA
ABC	hello
PQR	Hi

Now i want user1 to know data for department ABC and user2 for department PQR.

Till now what i did is

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD,DEPARTMENT
ADMIN, admin1, admin,*

USER,user1,user,'ABC'
USER,user2,user,'PQR'

];
SECTION Application;

but it is showing datas for both departments for each users.

[sbaldwin]

Hi, silly question but have you checked the Initial reduction based on section access checkbox?

Thanks

Steve

[SunilChauhan]

Use below code

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,DEPARTMENT

ADMIN, admin1, admin,*

USER,user1,user,ABC

USER,user2,user,PQR

];

SECTION Application;

Load * inline [

DEPARTMENT

ABC

PQR

];

see the attached file

hope this helps