I was creating a report and I noticed when I made used a subtotal, it would create it perfectly in the GUI.
But when I coded it using the "ON FIELD_NAME SUBTOTAL AS 'Description' "
It would create the background colors for all the columns and not just the columns it has totals for.
Is there a way to create it so that the Wording and background color only starts on the column that it was made "on" and not previous columns?
April 19, 2006, 05:02 PM
smiths
Ben,
Does this answer your question:
TABLE FILE CAR PRINT * BY COUNTRY ON COUNTRY SUBTOTAL AS 'Seats for: '
ON TABLE SET STYLE *
TYPE=SUBTOTAL, COLUMN=SEATS, BACKCOLOR=RED, $
ENDSTYLE END
Regards, SeanThis message has been edited. Last edited by: smiths,
------------------------------------------------------------------------ PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
April 19, 2006, 05:09 PM
reFOCUSing
Is this what you are trying to do?
TABLE FILE CAR
SUM
RETAIL_COST
DEALER_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL AS 'Description:'
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,SQUEEZE=ON,ORIENTATION=PORTRAIT,$
TYPE=REPORT,GRID=OFF,FONT='TIMES NEW ROMAN',SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$
TYPE=SUBTOTAL,BY=COUNTRY,COLUMN=P3,COLOR='RED',BACKCOLOR='BLACK',$
ENDSTYLE
END
April 21, 2006, 01:53 PM
BenC
I think you guys are on the right track, but the text should start on the column that it is "on".
Report Columns: COUNTRY COSTS PROFIT
If I do a subtotal on Costs, I want the Subtotal title to start under Costs, and not under Country.
April 21, 2006, 01:56 PM
Francis Mariani
If it does what you want in the GUI, then why don't you look at the source code generated by the GUI and do the same?
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
April 24, 2006, 12:04 PM
reFOCUSing
Is this what your are trying to do:
TABLE FILE CAR
SUM
RETAIL_COST AS 'Retail,Cost'
DEALER_COST AS 'Dealer,Cost'
SALES AS 'Sales'
BY COUNTRY AS 'Country'
BY CAR AS 'Car'
BY BODYTYPE AS 'Body'
ON CAR SUBFOOT
" <+0>Description:<CAR<+0><ST.DEALER_COST"
" "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,SQUEEZE=ON,ORIENTATION=PORTRAIT,$
TYPE=REPORT,FONT='ARIAL',SIZE=8,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,RIGHTGAP=0.00,LEFTGAP=0.00,$
TYPE=REPORT,COLUMN=P1 ,SQUEEZE=1.00,$
TYPE=REPORT,COLUMN=P2 ,SQUEEZE=1.00,$
TYPE=REPORT,COLUMN=P3 ,SQUEEZE=1.00,$
TYPE=REPORT,COLUMN=P4 ,SQUEEZE=0.75,$
TYPE=REPORT,COLUMN=P5 ,SQUEEZE=0.75,$
TYPE=REPORT,COLUMN=P6 ,SQUEEZE=0.75,$
TYPE=SUBFOOT,ITEM=1 ,JUSTIFY=LEFT ,WIDTH=1.00,$
TYPE=SUBFOOT,ITEM=2 ,JUSTIFY=LEFT ,WIDTH=0.75,$
TYPE=SUBFOOT,ITEM=3 ,JUSTIFY=LEFT ,WIDTH=1.00,$
TYPE=SUBFOOT,ITEM=4 ,JUSTIFY=RIGHT ,WIDTH=1.75,STYLE=BOLD,COLOR='RED',$
ENDSTYLE
END