Dear All,

Is there a way to print out the same row per PDF page by using PAGE-BREAK?

I will use the CAR table to show what I illustrate what I mean.

Let's say we have to following data:

  
CAR 	  CTR
JAGUAR 	   1
JENSEN 	   2
DATSUN 	   3
MASERATI   1
TOYOTA 	   2
AUDI 	   3
TRIUMPH    1
ALFA ROMEO 2
BMW 	   3
PEUGEOT    1

How can I manipulate the holding table to be something like:

  
CAR 	  CTR
XXXXXX     0
JAGUAR 	   1
JENSEN 	   2
DATSUN 	   3
XXXXXX     0
MASERATI   1
TOYOTA 	   2
AUDI 	   3
XXXXXX     0
TRIUMPH    1
ALFA ROMEO 2
BMW 	   3
XXXXXX     0
PEUGEOT    1

I can then basically use the PAGE-BREAK function so each PDF page will display the XXXXX value therefore

PAGE 1 will consist
XXXXXX 0
JAGUAR 1
JENSEN 2
DATSUN 3

PAGE 2 will consist
XXXXXX 0
MASERATI 1
TOYOTA 2
AUDI 3

PAGE 3 will consist
XXXXXX 0
TRIUMPH 1
ALFA ROMEO 2
BMW 3

And Page 4 will consist
XXXXXX 0
PEUGEOT 1

Any suggestion would be much appreciated. Thanks in advance

Define a field and put it in a heading.

DEFINE FILE CAR
HDFLD/A12='XXXXXXXX';
HDFLD2/D12=0;
END
TABLE FILE CAR
HEADING
"<HDFLD <DHFLD2"
SUM CTR.CAR
BY CAR
END
  

Thanks for the reply PBrightwell. Sorry but I forgot to mention, it has to be a row in the data.

Obviously you'll have to "invent" the data. You could use McGyver or you could filedef the output file using append and then table your main data into followed (or preceded) by your invented data -

FILEDEF BHS6868 DISK BHS6868.FTM (APPEND
-RUN
TABLE FILE CAR
SUM COMPUTE CAR/A16 = 'XXXXXX';
    COMPUTE CNTR/I3 = 0;
BY COUNTRY 
ON TABLE HOLD AS BHS6868 FORMAT ALPHA
END
TABLE FILE CAR
SUM COMPUTE CNTR/I3 = IF COUNTRY EQ LAST COUNTRY THEN CNTR + 1 ELSE 1;
BY COUNTRY
BY CAR
ON TABLE SAVE AS BHS6868
END
-RUN
TABLE FILE BHS6868
PRINT CAR CNTR
BY COUNTRY NOPRINT PAGE-BREAK
BY CNTR NOPRINT
END

T