Yiannis Posted February 5, 2003 Posted February 5, 2003 Can someone help me to find how can I make totals per page in preview mode please? I want for example in each page of a report in preview mode to have a total for an amount of all the records who fit in a page. If all records fit for example in 4 pages I want the total for each page. Is it difficult in filemaker? Because I can not found a page break for this like other databases products.
BobWeaver Posted February 6, 2003 Posted February 6, 2003 Have a look at this: http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB31&Number=48392&Forum=All_Forums&Words=subtotal%20%20page&Match=And&Searchpage=0&Limit=25&Old=allposts&Main=48392&Search=true#Post48392
Yiannis Posted February 9, 2003 Author Posted February 9, 2003 Bob, as I said it working great with summary fields in the subsummary trailing part but what happen when we are going to place a calculation field in this part? For example the summary fields Debit & Credit working great but the calculation field Balance (Debit - Credit)appear the number for the balance of all the records and not only from the records who belongs in a page.
BobWeaver Posted February 11, 2003 Posted February 11, 2003 Just make a calculated field that calculates debit-credit on each record, and then total this field the same as the credit and debit fields.
Recommended Posts
This topic is 7948 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 accountSign in
Already have an account? Sign in here.
Sign In Now