Good Day, I have a newbie question regarding passing date parameters in Report Assist. What I am trying to do is write a to - from parameter that can be left blank at the end user’s choice. I am just starting to use Report Assist and I’m sure that this is something that can be done. I’ve searched the forum and can’t seem to get anything to work. What I have right now will work if the parameter is entered.
WHERE SCHEDULE_DATE GE &START_DATE AND SCHEDULE_DATE LE &END_DATE
How do I change the code to accept or not accept this parameter?This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6 Windows, All Outputs
January 18, 2011, 11:16 AM
Prarie
Hi Welcome to the Forum. Do a search on FOC_NONE. This will make the Where statment be ignored.
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
January 18, 2011, 12:06 PM
dptywrdn
Thanks Prarie, I'll do that.
WebFOCUS 7.6 Windows, All Outputs
January 18, 2011, 12:52 PM
<JG>
Note. For FOC_NONE to work correctly the WHERE MUST be coded on 1 line.
It excludes lines of code, NOT statements.
January 18, 2011, 01:47 PM
dptywrdn
I've read that in other areas of the forum. I'm still having a bit of difficulty with this as I am working in Report Assistant and not DevStudio. Additionally, I am really new to the whole WebFocus way of coding. I have downloaded the Report Assist manual from IBI but it is pretty light on the parameter side of things. Is there other documentation that would help me out?
By the way thanks for the speedy responses Prarie and JG
