AnsweredAssumed Answered

More complicated charts

Question asked by DonBragger on Jan 21, 2011
Latest reply on Jan 31, 2011 by philmodjunk


More complicated charts


Hi all,

I was wondering if someone could help me with some charts. What I have is a simple database:

customer --< projects --<lineitems >--< invoice

What I would like to do is:

1) Report on the total amount invoiced for all customers within a date range. This I can do.I set up a start and end date in the customer field and related those with the customer_ID to the invoice table and summed the totals.

2) This is the bit I need some help with. How can I allow the user to select a company and show the total invoiced for particular projects for a given date range. I'm not sure which table it should be viewed from or how to quite set it up.

Thanks in advance.