Pre-Printed Form and Summary Field
-
- Posts: 11
- Joined: Tue Oct 10, 2017 12:44 pm
Pre-Printed Form and Summary Field
To my R&R Community,____I have a pre-printed form that has line totals using a record type band line(ie..$4, $5). Under the line totals field, i have a general statement "Call if any Questions" and a "Total Field" using a Summary band line. When i have fewer than 5 lines its fine. All lines up and my "Total Field" prints inside the box. However, when i have an instance where the next page is created, the "Total Field" prints outside my pre-printed box for Total. Why? Lookin^ for ideas.______thnks guys!
=> Pre-Printed Form and Summary Field
A summary band will always print after the last record/group line rather than relative to a position on the page.__One one to get what you want is to create a constant calculated field with the expression 1 and then make that a group field. This will have all of your records belong to this group (so a group footer would be the equivalent of a summary.) For this group field, check the swap footer box.__Then create a group footer that is the size from where your total box is to the bottom of the page. Put your total on this band line.__Then create a page footer that is exactly the same size as the group footer.__This should allow single and multiple page reports to always have the total in the same place on the page.____Kathleen__R&R Support