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

Roland, I am currently 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...

Roland, 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...

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 !");'...

Could you send the sample of the code ? Continuing with the 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...

The simple solution is similar 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...

If your output is HTML, you can use the following CSS style: .head_line { border-bottom : thick solid Black; } or something similar. Than you can reference it within your report, e.g.: SET CSSURL='/path/to/the/stylefile.css' TABLE FILE CAR ON TABLE SET PAGE-NUM OFF HEADING CENTER &quot...

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

Yes, using TOT. make the things simpler (two computes instead of three), and it also works with SUM: TABLE FILE CAR ON TABLE SET PAGE-NUM OFF SUM SALES COMPUTE CNTS/D12.2 = IF COUNTRY NE LAST COUNTRY THEN CNT + 1 ELSE CNTS; NOPRINT COMPUTE...

One of the solution is to COMPUTE the average value and then use it within SUBFOOT, for example: TABLE FILE CAR SUM SALES COMPUTE CNTS/D12.2 = IF COUNTRY NE LAST COUNTRY THEN CNT + 1 ELSE CNTS; NOPRINT COMPUTE TOTSAL/D12.2=IF COUNTRY NE LAST COUNTRY THEN TOTSAL+SALES...

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