[SOLVED] style sheet: how 2 reference subtotal fieldname
how do i reference in 'style sheet' terms that subtotal fieldname ON CAR SUBTOTAL AS '' how do i reference that value of car that shows up. i need to right adjust it. its gotta be easy but i'm blanking out...This message has been edited. Last edited by: Kerry,
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
August 29, 2008, 01:24 PM
Glenda
Susannah,
TYPE=SUBTOTAL,
JUSTIFY=RIGHT,
$
That should do it for you if I'm understanding what you've asked.
Glenda
In FOCUS Since 1990 Production 8.2 Windows
August 29, 2008, 01:47 PM
mgrackin
Susannah,
If you are showing the column for which you are doing a SUBTOTAL then you can use the following:
TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR ON COUNTRY SUBTOTAL AS '' ON TABLE SET STYLE * TYPE=SUBTOTAL, COLUMN=COUNTRY, JUSTIFY=RIGHT,$ ENDSTYLE END
If you have a NOPRINT on the BY field for which you are doing a SUBTOTAL then you need to apply the formating to the entire SUBTOTAL line and then reformat specific columns in the SUBTOTAL line back to "normal" formating.
TABLE FILE CAR SUM RCOST DCOST BY COUNTRY NOPRINT BY CAR ON COUNTRY SUBTOTAL AS '' ON TABLE SET STYLE * TYPE=SUBTOTAL, JUSTIFY=RIGHT, STYLE=BOLD,$ TYPE=SUBTOTAL, COLUMN=RCOST, STYLE=-BOLD,$ TYPE=SUBTOTAL, COLUMN=DCOST, STYLE=-BOLD,$ ENDSTYLE END
Thanks!
Mickey
FOCUS/WebFOCUS 1990 - 2011
August 29, 2008, 04:17 PM
susannah
hey Mick i tried BY=COUNTRY, JUSTIFY=CENTER and it 1) centered most(*not all*) of the data as well as the label 2) dropped the border styling
If i just do COLUMN=COUNTRY,JUSTIFY=CENTER nothing happens
I'm just going to go plain vanilla TYPE=SUBTOTAL,JUSTIFY=RIGHT, and its good enuf, it justifies the whole line, which is numeric, except for the label, so its *ok*.
muchas muchas gracias to you both
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
August 29, 2008, 04:39 PM
mgrackin
Susannah,
As I mentioned in my previous post, it depends on if you are showing the BY field as a column on the report or not.
If using BY COUNTRY without a noprint then you can directly change the JUSTIFY setting for the value of COUNTRY in the SUBTOTAL using COLUMN=COUNTRY.
If using BY COUNTRY NOPRINT then trying to do anything to the value of COUNTRY in the SUBTOTAL will not work as you experienced already.
The key is whether or not you are NOPRINTing the sort field.
