Focal Point
Setting up parameters on WebFOCUS Report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8691058331

May 12, 2005, 06:27 PM
awbradley
Setting 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
Spence
Try 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
awbradley
Thanks 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.