I need to create a launch page where the user can choose the type of date range: daily, week-to-date, month-to-date, etc.

At the top of the focexec, the code will branch to the logic for creating the beginning and ending dates, given the user's choice of date range, as shown below. The TABLE request has one WHERE statement: WHERE DATE_FIELD GE &BEGIN_DATE AND DATE_FIELD LE &END_DATE;



-GOTO &DATE_RANGE

-DAILY
...
-GOTO TABLE_REQUEST

-WTD
...
-GOTO TABLE_REQUEST

And so on.


WHERE statements are the basis of the controls in the HTML Layout Painter. How can I get the HTML Layout Painter to have radio buttons for &DATE_RANGE?

And if that's not enough, an option is "custom", meaning the user can supply any beginning and ending date. If the user chooses "custom", an input box for the beginning date and an input box for the ending date need to be available and pass their values to the focexec.

Please advise.

Thank you,

John

John,

I am going to assume that you are working with 7.x or above because you reference the HTML Layout Painter, not the Resource Layout Painter, and will try to answer your question accordingly. However, please update your profile signature with your release and platform so that we can more easily help you.

If you have &DATE_RANGE, &BEG_DAT, and &END_DATE in your program, create a page using the HTML Layout Painter and put a button on it. Right-click the button and choose hyperlink properties. In the window that comes up, choose external procedure to run and all the other stuff that goes with it. When you click OK, you should see a window that has all of your amper variables in it. They should be all checked. To the right is a column where you can choose what kind of control you want to have. Radio button is one of the controls. You can always change it later under Parameters.

Down at the bottom of this window is a pulldown box that asks you if you want to create a form or not. I always choose no but that is personal preference. I want the ability to move my text independently of my control.

Let us know how it goes.