[SOLVE] How to auto prompt with selection for variable that is not in WHERE statement
Is there any way in the fex to prompt the user for a parameter and supply selection values without the variable being used on a WHERE statement? In this example, I would want to ask the user if they wish to base the report on "order date", "ship date" and etc. and allow them to select one of these values (instead keying it in) but I'm not using this parameter on any WHERE statement (which is where I would normally supply the values).This message has been edited. Last edited by: Kerry,
________________________________________________________________________________________ WebFOCUS 7.6.8 + Windows Server 2003 + DB2/400
November 10, 2008, 01:13 PM
hammo1j
-SET &DUMMY = &EXCL.(No,Yes,Only).Exclude E001A and EPMGT Subprojects. ;
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
November 10, 2008, 01:21 PM
JDroke
Thank you so much hammo1j. That worked perfectly and gives me so much more flexibility in my fex.
________________________________________________________________________________________ WebFOCUS 7.6.8 + Windows Server 2003 + DB2/400
November 10, 2008, 01:40 PM
Darin Lee
&Variables are treated the same regardless of where they are used. Any unresolved &variables will be prompted for when the fex is run (if autoprompting is turned on.)
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat