Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GrSw
  • Order by date
  1. GrSw

    Substring of a variable

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

    *TOTAL with SUMMARIZE

    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
  3. GrSw

    *TOTAL with SUMMARIZE

    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...
  4. GrSw

    *TOTAL with SUMMARIZE

    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...
  5. GrSw

    No Page Break

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

    Row total and column total on specific columns only?

    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 + ...
  7. GrSw

    WebFocus variable in JavaScript

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

    Hello, I need to have multiple thi

    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...
  9. GrSw

    Hello, I need to have multiple thi

    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...
  10. GrSw

    Hello, I need to have multiple thi

    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...
  11. GrSw

    subprograms which are in separate files possible?

    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
  12. GrSw

    Removing Underline for Column Titles

    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...
  13. GrSw

    escaping ' within a String

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

    CGI Bin Jakarta-Tomcat

    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
  15. GrSw

    Webapp "cannt be displayed", but Tomcat default can

    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...
  16. GrSw

    Drop-down list page select

    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
  17. GrSw

    Averages

    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...
  18. GrSw

    Averages

    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...
  19. GrSw

    Drop-down list page select

    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>...
  20. GrSw

    Averages

    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

Part and Inventory Search

Back
Top