I have this report

TABLE FILE CAR
SUM 
     SALES
BY COUNTRY
ACROSS CAR
ACROSS MODEL
     ACROSS-TOTAL
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=ACROSSVALUE,
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     COLUMN=ROWTOTAL(1),
$
ENDSTYLE
END

I would like to see this across subtotal in an other color (or bold)

This must be possible but how?
ACROSS MODEL ACROSS-TOTAL

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

I've scanned all my code and it looks like it should be

TYPE=ACROSSVALUE, COLUMN=ROWTOTAL(n)

but I can't make this work.

Yes I thought that too, but could not make it work....

quote:

TYPE=ACROSSVALUE, COLUMN=ROWTOTAL(n)

Is this what you want??

quote:

TABLE FILE CAR
SUM
SALES
BY COUNTRY
ACROSS CAR
ACROSS MODEL
ON TABLE ROW-TOTAL
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=DATA,
ACROSSCOLUMN=N1,
COLOR='BLACK',
$
TYPE=ACROSSVALUE, COLUMN=ROWTOTAL(1), COLOR = RED,$
TYPE = DATA, COLUMN=ROWTOTAL(1), COLOR=RED,$

TYPE=ACROSSVALUE,
STYLE=BOLD,
$
ENDSTYLE
END

Leah,

Shouldn't there should be a way to style an ACROSS-TOTAL?

I played around with this in 762 and I couldn't make it work either.

According to the documentation, you can style an ACROSS-TOTAL by the numeric column reference, which is completely ridiculous as you may not know how many ACROSS values you have.
Example: Identifying Row Totals (ACROSS-TOTAL) for Horizontal Sort Data

TYPE=ACROSSVALUE, COLUMN=N8, STYLE=ITALIC, COLOR='RED', $

Frank,

You may have to rely upon FML, FRL, EMR or what ever it is called nowadays

T

I think some programmer inadvertently forgot to program styling for ACROSS-TOTAL columns, so IB decided to stick an example in the documentation that really does not solve the problem.

I found several 4.3.6 programs from a long time ago that used

TYPE=ACROSSVALUE, COLUMN=ROWTOTAL(n) or
TYPE=ACROSSVALUE, COLUMN=ROWTOTAL

Of course, I can't remember if that actually worked.

What LEAH did comes close tot the result, but as you might have noticed in my example there is a kind of "subtotal" in the across report for each "CAR".

Exactly that column is what I want to pay attention to by coloring it.

If you run this one, you may see what I mean

TABLE FILE CAR
SUM
SALES
BY COUNTRY
ACROSS CAR
ACROSS MODEL
   ACROSS-TOTAL
ON TABLE ROW-TOTAL
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=DATA,
ACROSSCOLUMN=N1,
COLOR='BLACK',
$
TYPE=ACROSSVALUE, COLUMN=N5, COLOR = RED,$
TYPE = DATA, COLUMN=N5, COLOR=RED,$

TYPE=ACROSSVALUE,
STYLE=BOLD,
$
ENDSTYLE
END

The Styling does work if you have an ACROSS With a ROW-TOTAL - I have several of those..but it does not seem to recognize ACROSS-TOTAL in styling...yes someone forgot something somewhere.

THANKS to everyone in this thread..
re: ACROSS CONDITIONAL STYLING (for future hunters)
just what i needed tonight.

here's what does the col title
TYPE=ACROSSVALUE,COLUMN=ROWTOTAL,BACKCOLOR=SILVER,$
and this worked for the data
TYPE=DATA,COLUMN=ROWTOTAL(&dtl_rt),COLOR=RED,WHEN=ROWTOTAL(&dtl_rt) LT 0,$
I created an &var (&dtl_rt) to figure out for me how many columns i was gunna have,
(actual budget variance or just variance)
so i could conditionally style code ONLY the variance rowtotal.
Couldn't have done it without you guys!

quote:

THANKS to everyone in this thread...

This is just what I needed today but forgot sometime before that .