quote:

with a date filte

Folloing is the table so i have the FYP value in my table but user is seletcing DATE Value in the parameter, so I cant use &DATE variable. I need FYP for the selected date in my heading. 
DATE          FYP
01/01/2010   201001
02/01/2010   201002
03/01/2010   201003

EX -LINES 4 EDAPUT FOCTEMP,TMP_FYP,CV,FILE
01012010 201001
02012010 201002
03012010 201003

EX -LINES 5 EDAPUT MASTER,TMP_FYP,CV,FILE
FILENAME=TMP_FYP, SUFFIX=FIX,$
SEGNAME=TMP_FYP, $
  FIELD=DATE,ALIAS=  ,DMYY ,A9 ,$
  FIELD=FYP,ALIAS=  ,A6    ,A6 ,$

FILEDEF TMP_FYP DISK tmp_fyp.ftm (LRECL 15

-RUN

-SET &Filter = '> 01/01/2010' ;

-SET &DateTemp= EDIT(&Filter,'$$9999999999');
-SET &DTest   = EDIT(&Filter,'99');
-SET &DTest   = DECODE &DTest('>' 'GT') ;

TABLE FILE TMP_FYP
HEADING
"Date From: <MIN.DATE"
"Selected Dates: &Filter"

PRINT *
WHERE DATE &DTest '&DateTemp'
END

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

-SET &ECHO=ALL;
-DEFAULTH &CAR=JENSEN
-* &CAR is the user selected value
-* Set up your dynamic fex
FILEDEF HOLD DISK dmfex.ftm (APPEND
-RUN
-WRITE HOLD -SET &|TITLE=
-* read the car file creating a matched pair  of value(CAR) and column heading(COUNTRY) for the value selected and write out the DM code
DEFINE FILE CAR
COUNTER/I9 WITH RCOST=COUNTER+1;
LINE1/A80=IF COUNTER EQ 1 THEN '- IF &|CAR EQ '|''''||CAR||''''||' THEN '|''''||COUNTRY||'''' ELSE
                                '- ELSE IF &|CAR EQ '|''''||CAR||''''||' THEN '|''''||COUNTRY||'''' ;
END
TABLE FILE CAR
PRINT LINE1
ON TABLE HOLD FORMAT ALPHA
END
-RUN
-WRITE HOLD - ELSE ' ' ;
-CLOSE HOLD
-* HOLD now contains a complete Dialogue Manager statement  which will take the value selected and populate &TITLE with the appropriate value.
-MRNOEDIT -INCLUDE dmfex.ftm
TABLE FILE CAR
PRINT CAR AS '&TITLE'
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,$
TYPE=TITLE, STYLE=BOLD,$
ENDSTYLE
END