I have an excel report with
on break-1 recompute as 'total '

The 'total break-1 ' prints on the first column of the excel file. I want it print on the second column; but, I can't seem to identify it on the stylesheet. I tried:

TYPE=SUBTOTAL, COLUMN=C1, POSITION=P2, COLOR=RED, $
OR
TYPE=SUBTOTAL, ITEM=1, POSITION=P2, COLOR=RED,$

Nothing works. I know it is not being identified because it does not even print red.
Thanks in advance.

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

Did you try this,
TYPE=SUBTOTAL, BY=break-1, .... $

Can you paste here the entire code?

I don't know whether there is a way to refer to the first item in a subtotal from the stylesheet, but you can reference all the other items in it.

Perhaps you can turn that around to something like this:

TYPE=SUBTOTAL, COLOR=RED,$
TYPE=SUBTOTAL, COLUMN=C2, COLOR=BLACK,$
TYPE=SUBTOTAL, COLUMN=C3, COLOR=BLACK,$
TYPE=SUBTOTAL, COLUMN=C4, COLOR=BLACK,$
...

Thanks. I know how to refer any other items. I just can't find a way to refer the first one. And I have to refer the first one because I want to position it somewhere else on the excel sheet.

I think you may need to use SUBFOOT in order to reposition text in a sub-total row.