Grouping

[SteveE]

I have a report where records are grouped by one field (order number) and I would like to print all the records under that order number on seperate pages totaled etc. for each order number.

Where do I specify this, I have tried the sorting and grouping options but dosent seem to work, the records are grouped and total etc but not on seperate pages.

any help appriciated.

Steve

 

[chrislee]

It sounds like you have a one-to-many scenario where a record identified by 'order number' has many child records.

You're looking in the right place: under sorting and grouping, you need to add the 'order number' field (you've probably got this already), and then you need to set 'Group Header' and 'Group Footer' propeties to 'Yes'.

This will give you a couple of extra sections on your report (something like 'Order number header' and 'Order number footer'). Now you can layout your report putting the 'order number' field in the header, the child record fields in the detail section, and any totals in the footer section.

Finally, you need to change the 'Force New Page' property on the footer section to 'After section' -- this will page break after each order number.

HTH,

Chris.

 

[SteveE]

Magic, it was the force new page which I could'nt find

thanks

Steve