I’m creating an order form using an XML database that Lists Ship Qty, Unit Price and a Total Price and it could be 1 or more records. (I do not have to do the calculation on these) But I have the Grand Total that adds up the Total Price fields. (I do not have to do the calculation on this either), but I do have a Grand Total label and a grand total amount that needs to follow at the end of the list of Total Price fields, that could be 1 or more records, with a line above it. How do I get it to follow in place with a line above it?
Here is a simple example with one record, with the Grand Total at the end and I would like a line above that total.
   Ship Qty            Unit Price             Total Price
        1               18.25                      18.25
                      Grand Total                  18.25
How do I get this to work? I’m new at this and no nothing about formulas or grouping. Any help would be appreciated.
Thanks ~ dc

Thank you. It is a grand total at the end of multiple orders, so I put it in the report footer. Now I would like to know who to set the page breaks it one order goes to a second page. Thanks again.
dc