I have successfully created a report with a blank row as a subfooter for a group of common records. The report has 2 distinct groups, and thus has 2 of these blank rows. I need these 2 blank rows to be a color other than white.

Here is what I have tried (only a small portion shown), and it does not work. What is wrong with my code, or is it possible that something else in the code is interfering? TRANSPORT_TYPE is the field used in the "BY" and the "ON ... SUBTOTAL" clauses.

ON TABLE SET STYLE *
TYPE=SUBFOOT, BY=TRANSPORT_TYPE, BACKCOLOR=RGB(100 100 100),$
ENDSTYLE

thanks

Richard Killey
WF Dev Studio 5.3.2

This message has been edited. Last edited by: MTO-Solutions-Engineering,

Richard,

Not sure why you are having trouble. Code below works for me. Is this what you tried?

TABLE FILE CAR
PRINT MODEL
BY CAR
ON CAR SUBFOOT
" "
" "
ON TABLE SET STYLE *
TYPE=SUBFOOT, BY=CAR, BACKCOLOR=RGB(100 100 100),$
ENDSTYLE
END

Richard,
you know there's a difference between SUBFOOT and SUBTOTAL, yes?
your code says ON ... SUBTOTAL
and your stylesheet says
TYPE=SUBFOOT,...
theu're not the same thing..you know that , right?
You see in Portland's code how he uses SUBFOOT for both?

Thank you DWF and Susannah. My code definitely has ON field SUBFOOT and then in the style section, TYPE=SUBFOOT.

I will play a bit more with it and if still not working will post a larger chunk of the code.

Richard

I should have been more specific. I have both a SUBTOTAL and a SUBFOOT. The end user wants a shaded blank line after the group subtotal.

ON TRANSPORT_TYPE SUBTOTAL AS 'Sub Total'
ON TABLE SUBTOTAL AS 'Grand Total'
ON TRANSPORT_TYPE SUBFOOT
" "

This successfully puts the subtotal on one line and that is followed by a blank line, but the shading does not occur.

Richard

ARRRGGGHHH

The report has a branch in it as it is meant to cover situations that need the extra footer and cases that do not need it. I inadvertently added an additional ENDSTYLE in the one branch. The error message I was getting, of course, sent me down the wrong rabbit hole and I had trouble coming back out.

The report now works fine, and I appreciate the two of you telling me that the code I had should work fine, which got me looking at other possible problems.

Richard

Richard,

This is where the new "Logical View" tab in Dev Studio editor becomes very useful .

T