I want to display the column titles anytime a group changes, and when it has a subhead (or subfoot).

Run the following example, I want the column titles "CAR", "MODEL", and "BODYTYPE" to appear each time the country changes.

TABLE FILE CAR
PRINT
CAR
MODEL
BODYTYPE
BY COUNTRY NOPRINT
SUBHEAD
" "
"END

Any ideas?


We are using WebFOCUS 7.1.3.

ON COUNTRY SUBHEAD

I tried "ON COUNTRY SUBHEAD" like so, but it still does not give me what I need. When it shows the next Country, I want it to show the column headings again.

TABLE FILE CAR
PRINT
CAR
MODEL
BODYTYPE
BY COUNTRY
ON COUNTRY SUBHEAD
" "
"END

Just shut off the default column titles and create your own like this. This would work for a text report. You would need to use a style sheet to line up the column titles for other formats.

Good luck

TABLE FILE CAR
PRINT
CAR AS ''
MODEL AS ''
BODYTYPE AS ''
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"CAR MODEL BODY TYPE"
"--- ----- --------- "
END
CAR MODEL BODY TYPE
--- ----- ---------
JAGUAR V12XKE AUTO CONVERTIBLE
JAGUAR XJ12L AUTO SEDAN
JENSEN INTERCEPTOR III SEDAN
TRIUMPH TR7 HARDTOP
CAR MODEL BODY TYPE
--- ----- ---------
PEUGEOT 504 4 DOOR SEDAN
CAR MODEL BODY TYPE
--- ----- ---------
ALFA ROMEO 2000 GT VELOCE COUPE
ALFA ROMEO 2000 SPIDER VELOCE ROADSTER
ALFA ROMEO 2000 4 DOOR BERLINA SEDAN
MASERATI DORA 2 DOOR COUPE
CAR MODEL BODY TYPE
--- ----- ---------
DATSUN B210 2 DOOR AUTO SEDAN
TOYOTA COROLLA 4 DOOR DIX AUTO SEDAN

Just is case you don't know about this:

BY COUNTRY PAGE-BREAK NOPRINT

Of course, that'll give you a page break every time country changes..... but that means the column titles will reprint.

The simplest way is to use
ON COUNTRY PAGE-BREAK
and put the value for COUNTRY in the HEADING instead of a SUBHEAD

HEADING
"
BY COUNTRY NOPRINT PAGE-BREAK

Column headings are always repeated after a PAGE-BREAK

OPALTOSH and dwf, excellent suggestions, and it satisfied what I was trying to do.

Thanks for your help!