[SOLVED] How to identify SUBTOTAL/RECOMPUTE AS 'XXX' text to apply styles?

Let's say I have a recompute row like this:

ON SORT_FIELD
RECOMPUTE AS 'Sub Total'
...

Now I need to format the text 'Sub Total', I tried this

TYPE=SUBTOTAL, BY=SORT_FIELD, ITEM=1,

or

TYPE=SUBTOTAL, BY=SORT_FIELD, COLUMN=N1,

none of these work. Can't find it in the documentation either.

Any idea?

This message has been edited. Last edited by: <Kathryn Henning>,

7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)

Posts: 147 | Location: Toronto (GTA) | Registered: May 25, 2005

Francis Mariani

Expert

posted

Hide Post

It appears this works - specify the subtotal column name, you can't style only the text, but you can style the text and the value:

TABLE FILE CAR
SUM
SALES
WHEELBASE
BY COUNTRY
BY CAR

ON COUNTRY SUBTOTAL AS 'TOTAL COUNTRY -'

ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='ARIAL', SIZE=9, BORDER=1, BORDER-COLOR=SILVER, $
TYPE=SUBTOTAL, COLUMN=COUNTRY, COLOR=BLUE, $

ENDSTYLE
END

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

bug

Platinum Member

posted

Hide Post

Thank you Francis!

It happens that the client wants to have normal style in the data column, bold for "Sub Total" text, and "Sub Total" has a different justification than the actual total numbers.

I may have to use SUBFOOT "

7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)

Posts: 147 | Location: Toronto (GTA) | Registered: May 25, 2005

Ignored post by bug posted

Show Post

Danny-SRL

Virtuoso

posted

Hide Post

Francis,

Nice.