Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

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

Featured Replies

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

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.