Search results for query: *

Hello Eva, Try this: -SET &WF = 'blubb'; -SET &ST = '?'; -SET &ST = SUBSTR(5, &WF, 2, 2, 1, &ST); Hope this Helps Grzegorz

Hi Roland, It simply should work, so I do not have any idea why it does not work for you. Could you post the code of your report ? If you already solved it, post the solution, just letting the other know. Regards Grzegorz

...using WebFOCUS 5.2 (NT & Solaris), and the sample report: TABLE FILE MOVIES ON TABLE SET PAGE-NUM OFF SUM COPIES COMPUTE SALES/D12.2 = COPIES * LISTPR; BY CATEGORY BY RATING BY MOVIECODE ON RATING RECOMPUTE AS 'SumLabel' ON CATEGORY RECOMPUTE AS 'AnotherLabel' ON TABLE COLUMN-TOTAL...

...If memory serves me, it is impossible when using SUMMARIZE or SUB-TOTAL. The labels for the automaticaly SUMMARIZEd columns are always of the form '*TOTAL column_name column_value'. The solution is to use RECOMPUTE, instead of SUMMARIZE and SUBTOTAL instead of SUB-TOTAL, so your report could...

Yes: SET LINES=999999 or TABLE FILE XYZ ON TABLE SET LINES 999999 ... END Hope this helps Grzegorz

With the COLUMN-TOTAL there should be no problem. You can use the syntax ON TABLE SUBTOTAL column_name AS 'Title' or use SUBFOOT to have even more control on values displayed in the report. With ACROSS there is not so easy, the only thing I can find is to use the column notation C1 + C3 + ...

Hello Eva, WebFOCUS amper variables are resolved to their text representation before the -HTMLFORM is generated on the web server, so within JavaScript these variables will be simply "the text". Below is a very simple example: -SET &VARMSG='alert("The message !");'...

...example : TABLE FILE CAR HEADING CENTER "HEAD1" " " "HEAD2" " " SUM SALES BY COUNTRY ON TABLE SET STYLE * TYPE=REPORT, RIGHTMARGIN=6, $ TYPE=HEADING, STYLE=NORMAL, SIZE=1, BACKCOLOR=BLACK, LINE=2, $ TYPE=HEADING, STYLE=NORMAL, COLOR=RED, FONT=ARIAL...

...to this: TABLE FILE CAR HEADING CENTER "HEAD1" " " "HEAD2" " " SUM SALES BY COUNTRY ON TABLE SET STYLE * -* The RIGHTMARGIN should be set to fit the "thicklines" -* to the size of the report: TYPE=REPORT, RIGHTMARGIN=6, $ TYPE=HEADING...

...TABLE SET PAGE-NUM OFF HEADING CENTER " HEAD1 " " " " HEAD2 " " " SUM SALES BY COUNTRY ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, $ TYPE=HEADING, STYLE=BOLD, $ TYPE=HEADING, CLASS='head_line', LINE=2, $ TYPE=HEADING, CLASS='head_line', LINE=4, $...

Eva, I cannot receive the 1023 error in any way, but there are resolved casea on the IBI TechSupport pages. The solution to avoid the error is to use: -MRNOEDIT BEGIN and -MRNOEDIT END while using -INCLUDE Hope this helps Grzegorz

If your output is HTML, you can use something like: HTMLCSS=ON TABLE FILE CAR SUM SALES BY COUNTRY ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, $ TYPE=TITLE, STYLE=-UNDERLINE, $ END STYLE END for the PDF format, you can try something similar to: TABLE FILE CAR ON TABLE SET PAGE-NUM OFF...

Hello Eva, Use double ' : -SET &IF_HVNL = ' IF HVNL EQ ''S'' ' ; Hope this helps Grzegorz

Rich, I do not think it will work that way, try to configure your IIS server to run CGI, with the Tomcat to run JSP and servlets. Read the FAQ 'Integrating IIS with Tomcat' on this forum. You can also use Apache instead of IIS. Hope this helps Grzegorz

By default Tomcat can see the the web application in at least two cases: 1. Web application is the direct subdirectory of the $CATALINA_HOME/webapps, and has the subdirectory WEB-INF containing the valid web.xml. 2. There is a <Context ...> entry in the $CATLINA_HOME/conf/server.xml file...

Just use the relative URL paths within option values: <option value=&quot;../page_name.html&quot;> or <option value=&quot;pages/page_name.html&quot;> Hope this helps Grzegorz

...LAST COUNTRY THEN CNT + 1 ELSE CNTS; NOPRINT COMPUTE AVGSAL/D12.2=TOT.SALES/(TOT.CNTS-1); NOPRINT BY COUNTRY ON TABLE SUBFOOT -* The COMPUTEd value is used in the SUBFOOT below: &quot;TOTAL AVERAGE:<AVGSAL&quot; ON TABLE SET STYLE * TYPE=TABFOOTING, HEADALIGN=BODY...

...LAST COUNTRY THEN TOTSAL+SALES ELSE TOTSAL; NOPRINT COMPUTE AVGSAL/D12.2=TOTSAL/CNTS; NOPRINT BY COUNTRY ON TABLE SUBFOOT -* The COMPUTEd value is used in the SUBFOOT below: &quot;TOTAL AVERAGE:<AVGSAL&quot; ON TABLE SET STYLE * TYPE=TABFOOTING, HEADALIGN=BODY...

An example: <html> <head> <script language=&quot;javascript&quot;> <!-- function changePage(frm) { var selObj = frm.selPage; for (var idx=0; idx < selObj.length; idx++) { if (selObj[idx].selected) { document.location = selObj[idx].value; } } } //--> </script> </head> <body>...

Correction: [b]It does not produce the correct results !!![b] But I think that combination of COMPUTEs, RECAP and HEADALIGN stylesheet, could lead to the proper solution. Maybe there is even simpler way ? Let me know if you found the solution, or not. Grzegorz