Focal Point
(closed)just upgraded to 7.703

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

September 27, 2011, 02:24 PM
Donald
(closed)just upgraded to 7.703
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,


Prod: WebFocus 7.7.3 Win 2003
Dev: WebFocus 7.7.3 Win 2003
September 27, 2011, 02:41 PM
njsden
Check under:

WebFOCUS Administration Console > Configuration > Parameter Prompting

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.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
September 27, 2011, 04:09 PM
Donald
That did it... Thank You


Prod: WebFocus 7.7.3 Win 2003
Dev: WebFocus 7.7.3 Win 2003
September 28, 2011, 01:09 PM
Donald
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

  
jsData.ampers[i].name = "RPTNAME";
  



Prod: WebFocus 7.7.3 Win 2003
Dev: WebFocus 7.7.3 Win 2003
September 28, 2011, 01:14 PM
Todd_Wallace
quote:
"RPTNAME";

If that variable is unimportant to you you can
 -DEFAULT &RPTNAME = 'FOC_NONE' 

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.

  
jsData.ampers[i].name = "RPTNAME";
jsData.ampers[i].fieldName = jsData.ampers[i].name;// "Field" + i;
jsData.ampers[i].type = "default";
if( jsData.ampers[i].type == "unresolved" || jsData.ampers[i].type == "default" || jsData.ampers[i].type == "prompt" )
jsData.ampers[i].inForm = 1;
else
jsData.ampers[i].inForm = 0;
jsData.ampers[i].format = "";
jsData.ampers[i].min = "";
jsData.ampers[i].max = "";
jsData.ampers[i].strDef = 'FOC_NONE';
  



Prod: WebFocus 7.7.3 Win 2003
Dev: WebFocus 7.7.3 Win 2003
September 28, 2011, 03:33 PM
Donald
WORKING FINE NOW, JUST NEEDED TO FOLLOW ABOVE INSTRUCTIONS.


Prod: WebFocus 7.7.3 Win 2003
Dev: WebFocus 7.7.3 Win 2003