AnsweredAssumed Answered

Reporting

Question asked by Jason_Farnsworth on Sep 20, 2012
Latest reply on Sep 21, 2012 by comment

Looking for some advice on creating a report.

 

I have data in 3 tables

 

1. Jobs

2. Invoice

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?

 

Header

Sub-Header Leading

Body

Footer

 

or

 

Header

Body

Sub-header following

Footer

 

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,

 

Jason

Midland, Tx

Outcomes