To make a report better readable I would like to add a blanc line under the subtotal ONLY when there is a subtotal.
I tried something like

ON CLTNR_REF SUBTOTAL MULTILINES AS 'subtotaal'
ON CLTNR_REF SUBFOOT
" "  
WHEN &LINES GT 1;

But this won't work....
Suggestions?

Hello Frank,

MULTILINES works with most ON operations.
Try the following:


ON CLTNR_REF SUBTOTAL MULTILINES AS 'subtotal'
ON CLTNR_REF SUBFOOT MULTILINES
" "

Regards,

{CODE]TABLE FILE CAR
COUNT
MODEL NOPRINT
BY COUNTRY
SUM
SALES
BY COUNTRY
BY MODEL
ON COUNTRY SUBTOTAL MULTILINES
ON COUNTRY SUBFOOT
" "
WHEN C1 GT 1
END[/CODE]In my example, see FRANCE - no blank line. But, in my opinion, this doesn't make the report easier to read...

Daniel, that's a new one for me! Thanks!

TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY MODEL
ON COUNTRY SUBTOTAL MULTILINES
ON COUNTRY SUBFOOT MULTILINES
" "
END

Thanks Danny

that is great....

thanks Francis....you are right, it remains unreadable and makes it in fact even more confusing....
I have got questions from the end users and thought this would help...It does not.

but the MULTILINES does not work a subhead...

thanks anyway.

Look for "Creating a Sort Heading or Footing" in the documentation. No MULTILINES for SUBHEAD - probably because FOCUS doesn't know how many lines yet when creating the SUBHEAD.

Frank and Francis,

Try this:
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL MULTILINES
ON COUNTRY SUBFOOT MULTILINES
" "
END

See what happens after FRANCE

So if there are no Sales...it does nothing..interesting.