I have a Subtotal that looks like
Total Intangibles $1.00

Where the Total is put in by the system
and the "Intangibles" is something I added.

Is it possible to color the Total black, and the word "Intangibles" in red? The report painter only lets us change the text color for all.

This message has been edited. Last edited by: Kerry,

Jason,

I can't think of a way to do this.

In HTML there is a CSS pseudo-element called first-letter but there isn't one for first-word.

W3Schools: CSS Pseudo-elements

If the output is html, you can code the html tags into the text and they will appear correctly when the report is displayed.

TABLE FILE CAR
PRINT CAR RCOST
BY COUNTRY 
ON COUNTRY SUBTOTAL AS 'Total <font color=RED>Retail Cost</font>'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
ENDSTYLE
END

Other than that, there really isn't a way to use a WF stylesheet to accomplish what you're looking for.

Jason,

Can you post the code that generates the SUBTOTAL? From the way you are descibing it, it sounds like you might be using a SUBFOOT to generate the subtotal line. Your desciption in your first post is a bit confusing when you say YOU added the word intangibles and the SYSTEM/FOCUS put the word total in there. Normally when you override the default row title for the SUBTOTAL line you completely replace the default text not half and half.

This workd for HTML and EXL2K:

TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY CAR
BY MODEL
ON COUNTRY SUB-TOTAL AS '<SPAN STYLE="COLOR: RED;">TOTAL</SPAN>'
-*ON TABLE PCHOLD FORMAT EXL2K
END

Jason,

Developing on Francis's idea:

  
TABLE FILE CAR
SUM 
     SALES
BY COUNTRY
BY CAR
BY MODEL
     
ON COUNTRY SUBTOTAL AS '<SPAN STYLE="COLOR: BLACK;">Total</SPAN>' 
ON TABLE SET STYLE *
TYPE=SUBTOTAL, COLOR=RED, WHEN=COUNTRY NE 'FRANCE', $
TYPE=SUBTOTAL, COLOR=BLUE, WHEN=COUNTRY EQ 'FRANCE', $
TYPE=SUBTOTAL, COLUMN=SALES, COLOR=BLACK, $
ENDSTYLE
END

Or, for multi-colored subtotal text:

  
TABLE FILE CAR
SUM 
     SALES
BY COUNTRY
BY CAR
BY MODEL
     
ON COUNTRY SUBTOTAL AS '<SPAN STYLE="COLOR: BLACK;">Total </SPAN><SPAN STYLE="COLOR: red;">Country</SPAN>' 
ON TABLE SET STYLE *
ENDSTYLE
END