I have created a sales and inventory database which currently generates an invoice (Report) with Customer billing & shipping information plus a listing of the items purchase, quantities, extended prices, and totals.
Now I need to create customized invoices with slightly different information based on whether the customer paid with a credit card or not, and a pick for shipping & handling type, and whether there is a special notice at the bottom of the invoice.
Am not sure the best way to proceed. Have three separate invoice Reports, or have one Report with fields that hide or not depending on selections.
Thank you in advance for any advice.