Dynamic Print Titles according to content

[zendford]

Hello,

I have a blank excel as a template which I use to fill it with data from a database using excel automation in delphi 5 (yeah, it's an old application).

The format of the excel sheet is the following :

Two fixed titles on the first page.

1) One row containing the code and description of the group.
2) One row containing the titles of the columns from A to E
3) A variable number of rows for the actual data
4) Two rows containing summary info for the group.

After the second summary row I insert a page break so that each group will start on a new page.
What I haven't found so far is how to repeat on the top of each page rows 1) and 2) per group when group spans in several pages. Or if that is not possible, how to repeat 2) which has fixed titles.

For some reason I couldn't upload a sample so I've copy-pasted from excel.

Thank you very much for any help

Big Title on first page

Secondary title on first page

category number and description
F1 F2 F3 F4 F5
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
Total group number : 99
Total amount : 999.99
category number and description
F1 F2 F3 F4 F5
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
Total group number : 99
Total amount : 999.99
category number and description
F1 F2 F3 F4 F5
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
9 9 99999999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99.99
Total group number : 99
Total amount : 999.99

[:) Sixthsense :)]

Please show it in excel with expected result for better understanding

[zendford]

Tried to upload it but I couldn't. Sorry.