I am trying to create customer statements to be sent out to our students each month. I have a Students table and a Transactions table, The student can have multiple deposits and withdrawals each month. The statement should show the beginning balance for the month, then all transactions for the month, then the ending balance. I am able to create a this report, but only if I choose one student, then print it, then another student, print it, etc. So, I may not have chosen the right approach in creating the report There are over 100 students to print, so I would like to be able to print the whole batch at once. One page per student.
It seems that statements should be a common function, but I don't see too much in the forums. Can anyone help with this?
We'd need to get a clear picture of your transactions table to be sure, but a sub summary part set up with "when sorted by" specifying the student name or an ID number could be made to produce the statements that you want.