Looking for some advice on creating a report.
I have data in 3 tables
3. Invoice Line Items
I am trying to set up a report that will print the invoice properly but getting stuck.
I have customer and job information with in jobs
I would like this info in the Header
I have Invoice details
I would like this also on the header
I have the invoice line items
I would like this line itemed out in a report showing each one listed
I have total information (currently I have this stored in invoice line items)
I would like to total all the line times
What would be the correct report layout?
Or maybe another alternative? Which table would I based the report on? Jobs, Invoice, or Invoice Lineitems? Which would I link back to to sort the Sub-Header?
Any help would be great thanks,