Ordering a Report

[Aeon.Divine]

Hi there, I'll try to make myself clear:

I have a report with 3 headers.

Purchase Order Number
> Product Floor
> Product Area

The structure of my report goes like this:

PURCHASE ORDER header
Purchase Order Data header
Floor Header
Area Header ( This one also holds inside the product description table beggining )
Detail
Etc.

Now, here goes the problem. Every Purchase order needs to start a new page ( Ive already configured this from the properties menu ) and every new page needs to show again the floor header, and the area header, along with the product description table beggining ). How do i tell a simple header to appear in every page if its not the report header nor the page header ? ( This is due to the fact that the purchase order data header MUST go above the floor and area headers. )

I'll apreciate any advice you have to give me.
Many thanks in advance.

 

[ByteMyzer]

For each group header that you wish to display on all pages, set the RepeatSection property to Yes.

 

[Aeon.Divine]

Done, thanks!

Now i've got another little inconvenient. having three headers, i need the report to start in a new page each time a new header is set. I know the property, but i have a problem using it, cause if i set my three headers that way, then my first page will contain just the first purchase order header, the second page just the first floor header, the third just the first sector header...

What i need is to find myself in a new page every time a header changes EXCEPT for the first time the header is set INSIDE the bigger header that contains it.

What i mean is that this error shouldnt occur the first time i set a floor inside a purchase order, nor it should happen the first time i set a sector inside each floor.

I think this is a little more tricky...but please, any ideas ?

 

[ByteMyzer]

In the Report Sorting-and-Grouping, make sure each of the following is set (with the actual field names, of course):

Field/Expression      | Sort Order | Group Header | Group Footer
----------------------------------------------------------------
Purchase Order Number | Ascending  | Yes          | No
Product Floor         | Ascending  | Yes          | No
Product Area          | Ascending  | Yes          | Yes

For each of the Group Headers, make sure the RepeatSection property is set to Yes.

For the Group Footer for the Production Area field, set the ForceNewPage property to After Section.

 

[Aeon.Divine]

Problem solved, it wasnt exactly what i needed but doing so i found out my mistakes, thanks a lot, i'll add to your rep ^^.