I've an Order table with several Lines related to it. A Line belongs to an Order by using a relationship. I would like to make a print of this Order.

I tried with a layout related to Order with 3 parts : header, body and footer.

In header is all the information about the order (customer name, order number etc). In the body I want to see all the Lines related to this Order. I want this body to grow with the number of Lines.

The footer contains the total price, rebates etc...

This is really basic but it's not easy to do.

But I'm unable to get that. Can you tell me how to do that?

Thank you for your help

You do this kind of report from the *related* file. Use the Go to Related Record [show, relationship ] script step to find all the related records that match the current record, then change to the related file.

Build a layout in the related file with a Leading Grand Summary that contains all the oder information (this will be brought in through a relationship back to the Orders database). Each Line record goes into the body of the layout.

Thank you for your help! It was reaaly helpful!