April 5, 200619 yr 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