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!

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

Styling row-totals and ON statements 1

Status
Not open for further replies.

kaeserea

Programmer
Feb 26, 2003
164
DE
Hello!

I'd like to style my report. Can anybody tell me how to affect the column of a ROW-TOTAL, the rows of a COLUMN-TOTAL and the rows of ON TABLE ... statements?

For all these, the titles should be bold and the the cells should be light grey.

Thanxs for help.
Eva
 
The TYPE= value would be SUBTOTAL, ROWTOTAL, SUBFOOT, SUBHEAD, and GRANDTOTAL. After the TYPE, you could indicate each field or text item.

For example...
TABLE FILE CAR
PRINT CAR MODEL SEATS
BY COUNTRY
ON COUNTRY SUBTOTAL
ON TABLE SET STYLE *
TYPE=SUBTOTAL, STYLE=BOLD,$
TYPE=SUBTOTAL, FIELD=SEATS, BACKCOLOR='LIGHT GRAY',$
TYPE=GRANDTOTAL, STYLE=BOLD,$
TYPE=GRANDTOTAL, FIELD=SEATS, BACKCOLOR='LIGHT GRAY',$
ENDSTYLE
END
 
Hi Gizzy!

TYPE=GRANDTOTAL works, but not TYPE=ROWTOTAL nor TYPE=ROW-TOTAL nor TYPE=COLUMN-TOTAL. I get the error FOC3202

Eva
 
COLUMN-TOTAL is not a valid type - you would use GRANDTOTAL for this as well as for SUBTOTAL, SUB-TOTAL, RECOMPUTE and SUMMARIZE (use TYPE=SUBTOTAL for all lines in between). (for the last line). As far as ROWTOTAL, my apologies, I thought this was a valid type but it is not. Instead you would use TYPE=DATA, COLUMN=ROWTOTAL, STYLE=BOLD, etc.,$
 
Hi gizzy!

Thanx, the TYPE=DATA, COLUMN=ROWTOTAL, STYLE=BOLD, etc.,$ works!

Yet TYPE=SUBTOTAL does not work for my subtotals. Here is my code:
[tt]
TABLE FILE CAR
SUM SALES
BY COUNTRY
ON COUNTRY SUBTOTAL AS 'total in country'
END
[/tt]

How would you style the ON COUNTRY ... ?

Eva
 
TABLE FILE CAR
SUM SALES
BY COUNTRY
ON COUNTRY SUBTOTAL AS 'total in country'
ON TABLE SET STYLE *
TYPE=SUBTOTAL, SYTLE=BOLD,$
TYPE=GRANDTOTAL, STYLE=BOLD,$
ENDSTYLE
END

If you have multiple ON field SUBTOTALS that require different styling you could use
TYPE=SUBTOTAL, BY=fieldname, COLOR=RED,$
 
Hi gizzy!

Tnax a lot. The last line with the BY=fieldname works! Great.

Eva
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top