This code would prompt for a variable in earlier versions for the user to input, but now just give an error.
TABLE FILE GGORDER ON TABLE SET PAGE-NUM OFF HEADING "Orders Summary" SUM QUANTITY AS 'Units Ordered' BY HIGHEST 1 ORDER_DATE AS 'Order Date' BY PRODUCT_DESCRIPTION WHERE PRODUCT_DESCRIPTION EQ &PRODUCT_DESCRIPTION; ON TABLE NOTOTAL ON TABLE HOLD FORMAT HTMTABLE AS ggord2 ON TABLE SET STYLE * UNITS=IN, PAGESIZE='Letter', LEFTMARGIN=0.250000, RIGHTMARGIN=0.250000, TOPMARGIN=0.250000, BOTTOMMARGIN=0.250000, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, FOCEXEC=NONE, FONT=TIMES NEW ROMAN, SIZE=10, COLOR=YELLOW, BACKCOLOR=BLACK, STYLE=NORMAL, GRID=OFF, $ TYPE=HEADING, SIZE=12, STYLE=BOLD, $ END -HTMLFORM blkord2
This message has been edited. Last edited by: Donald,
ibi_wfdescribe is probably set to OFF. Changing its value to something like XMLRUN will enable prompting on reporting server procedures. Please check documentation for other possible values depending on what you need to achieve.
A new issue has arose.. Now that parameter prompting is on, All of my GUI front ends that were created with the composer are now promting for something called RPTNAME
or use FOC_NULL once they get rid of the old one. It will ignore the ENTIRE where statement that references that variable including any other AND or OR's attached to it.
WebFOCUS 8.1.05 Windows-iSeries DB2, All Outputs HTML
September 28, 2011, 01:33 PM
Donald
All that did was populate the input box with the work foc_none.