Hi,

I have to pass 3 values from Report and i should be able to store these values in a local variable in webfocus.
Further down, i should be able to assign this variable to any condition i put in where clause in the webfocus.
The aim is to sort data according to those parameters.
How can i achieve this. Required Urgently.

I'll give your question a try..... and maybe it will help you get a little further....

After you print the fields from the table you want, do an ON TABLE SETSTYLE

the FOCEXEC is the program you want to execute using the parameters

VAR1 is the first variable and is equal to the value in the fourth column. (Keep in mind that even a BY field NOPRINT is considered a column)

VAR2 is the second variable and the value in column one

VAR3 is the third variable and the value in column 8

COLUMN=4 is the column that is clicked to drill into the program with these variables

VAR1,VAR2,VAR3 are then the variables used in the where clause in PGMTOGOTO

ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, $
TYPE=DATA, FOCEXEC=PGMTOGOTO(VAR1=N4 VAR2=N1 VAR3=N8), COLUMN=N4, $
ENDSTYLE

Hope this helps even a little.....