How to print multiple reports(vouchers) using a single criteria 1

[teejoong]

i need a help here.. I have a table that have many payment records under one supplier name/id. How do I create a report that will print out the payments record based on the supplier name. I need to print out in the form of a voucher . One payment record one report/voucher.

Thank you

 

[THWatson]

teejoong
Ideally, you should have a table for Suppliers and a separate table for Payments. The SupplierID in the Suppliers table would be a foreign key in the Payments table, so that the two tables would be linked by that SupplierID.

Perhaps this is what you have, but from your post I wasn't sure.

Then you can design your report so that you have the first level of Sorting and Grouping by SupplierID, and a second level of Sorting and Grouping by PaymentID. Then you would force a page break after the Detail section, and that would put one Payment on each page.

Before you run the report, are you also wanting to select the Supplier for which you want the report to print? If so, then a method needs to be created to do that. You will have to provide further information regarding how you have things set up before I could comment further.

Tom

 

[teejoong]

Thanks THWatson.. I think I know what to do now.. Thank for your post