Jump to content

Line Items table report for multi-page "bookings" parts/footer issues


This topic is 5726 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Bit stumped with this one. (Just moved from older listserve lists to this fab new forum, so hello : )

I have a bookings system, master record BookingID, client details etc. Line items: date, details, cost etc.

The booking report needs the Header with the Client address, booking codes etc. Then all line items to be shown in detail section, then a footer *per booking* as a confirmation return slip the client sends back signed with payment.

Obviously I can't use a portal for this report and report directly from the master table, as there could be 1, 2 or 50+ line items per booking.

Therefore I've based the report on the line items table, and used:

1. Sub-Summary(leading) by BookingID for the header,

2. Body for the line items,

3. Sub-Summary (trailing) for the grand total, and finally,

4. Footer for the return slip which always needs to be at the bottom of the page.

Naturally the system sorts by BookingID to ensure this report works correctly.

This works fine, and copes with multi-page bookings (with more than a page full of lines), but obviously the footer (return slip) appears on all the pages of multi-page bookings.

If I put the slip in the Trailing summary, I can't get it to appear at the bottom of the page, as it'll float above to the last line item.

Any ideas?

Thanks :D

Link to comment
Share on other sites

This topic is 5726 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.