May 12, 2005, 06:27 PM
awbradleySetting up parameters on WebFOCUS Report
I am creating a new report in which I want to prompt the user to enter a date. If the date is left blank I want to default to the current date. Any suggestions on how I can accomplish this? We are using WebFOCUS 5.3.3.
Thanks!
May 12, 2005, 08:16 PM
SpenceTry this.
&RPTDATE is the date to be entered by the user.
-SET &TODAY = &DATEMDYY;
-SET &RPTDATE1 = IF &RPTDATE EQ ' ' THEN &TODAY ELSE &RPTDATE;
TABLE FILE XXX
PRINT XXX
BY XXX
WHERE XXX GE '&RPTDATE1';
END
May 12, 2005, 09:38 PM
reFOCUSing-DEFAULT &WFFMT = 'HTML'
or
-PROMPT &WFFMT.(HTML,PDF,EXL2K).
Here are two more ways to do this.
May 13, 2005, 07:49 PM
awbradleyThanks for the suggestions. What I am trying to do is to display the default value, which I have set to be the current date, in the box where the user will enter the desired AS OF date.