HOW TO CREATE SECTION ACCESS?

[#1]

HI,

I CREATED SECTION ACCESS LIKE THIS AFTER I SELECT INTIAL DATA REDUCTION BASED ON SECTION ACCESS CHECKBOX. AND PROHIBIT BINARY LOAD CHECK BOX. THE PROBLEM IS WHEN I ENTER MY USERNAME PASSWORD IT SHOW USER DETAILS AT THE SAME TIME ENTER ADMIN USERNAME AND PASSWORD BUT IT SHOW ONLY ONE USER RECORDS.I WANT TO DISPLAY DATA LIKE THIS .IF I ENTER USER NAME AND PASSWORD IT SHOW ONLY USER DETAILS

.IF I ENTER ADMIN USER NAME AND PASSWORD THE APPLICATION SHOW ALL RECORDS.BUT I DO NOT KNOW HOW TO DO IT . PLS TELL ME OUT HOW TO DISPLAY LIKE THIS

.IF I ENTER USER NAME AND PASSWORD IT SHOW ONLY USER DETAILS

.IF I ENTER ADMIN USER NAME AND PASSWORD THE APPLICATION SHOW ALL RECORDS

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER, MSR, MSR

    USER, KSR, KSR

];

Section Application;

LOAD *

Inline [

USERID,Product

MSR,LAPTOPS

KSR,TVS

];

                                             THANKYOU,

REGARDS:

MADHU

[Anonymous]

I wouldn't recommend using resereved field (like USERID in your case) for data reduction.  In the following example, I changed USERID to USER_ID in the section application, and added a field specifically for data reduction, called it REDUCTION.  Notice that the value of this field for ADMIN is * - that means all listed values.

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD, REDUCTION
    ADMIN, ADMIN, ADMIN, *
    USER, MSR, MSR, MSR
    USER, KSR, KSR, KSR
];

Section Application;

LOAD *
Inline [
USER_ID,Product, REDUCTION
MSR,LAPTOPS, MSR
KSR,TVS, KSR
];

[philipp_ebner]

Hi Madhu,

this should work:

Star is *;

Section Access;

LOAD * INLINE [
  ACCESS, USERID, PASSWORD
  ADMIN, ADMIN, ADMIN
  USER, MSR, MSR
  USER, KSR, KSR
];

  Section Application;
LOAD *
inline [
USERID, Product
  ADMIN,*
  MSR,LAPTOPS
  KSR,TVS
  ];

Regards Philipp