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...
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
"...
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...
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="../page_name.html">
or
<option value="pages/page_name.html">
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.