Help with Row Headers

[jpack23]

Hi all,

I am having a problem getting my row header correct. For some reason they are repeating for each group. I dont if they are call row header or column headers but this is how my report looks

orders by Person
date

Name Column1 Column2 Column3
George Smieth
Order1 13 14
order2 15 16


Name Column1 column2 Column3
John Doe
Order1 13 14

Name Column1 Column2 Column3
Jane Doe
Order1 12 13

-----------------page break--------------------

orders by Person
date

Name Column1 Column2 Column3
David Brown
Order1 13 14
order2 15 16


Name Column1 column2 Column3
Susan Green
Order1 13 14


Name Column1 Column2 Column3
Sally Johnson
Order1 12 13



notice how Name Colum1, column2 and column3 header appear before each group. I only want those header to appear on the beginning of each page. For example

orders by Person
date

Name Column1 Column2 Column3
George Smieth
Order1 13 14
order2 15 16


John Doe
Order1 13 14


Jane Doe
Order1 12 13

-----------------page break--------------------

orders by Person
date

Name Column1 Column2 Column3
David Brown
Order1 13 14
order2 15 16


Susan Green
Order1 13 14


Sally Johnson
Order1 12 13

Thank you for your help

Joe

 

[xlbo]

Insert a row "Outside Group Above" and put your header values in that

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question