Forum Discussion

SarahWallis's avatar
SarahWallis
Qrew Trainee
8 years ago

Report: Month over Month - Many to Many

Hello. I have tables of "Invoices", "Lines"  and "Invoice-Line" to create the many to many relationship.

I need to create a report that lists some information about the Line (maybe the name and location) and the dollar amount each month's invoice. How do I do this? Example below. (I am open to other formats as necessary).

Ideally, I would be able to have multiple pieces of information from the Invoice as well, for example the Base Cost and the Total Actuals.

  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    Depending on how you have the information you should be able to do this already.

    Experiment with a summary report.  Particularly the grouping options.

    You might have to make sure that all those dollar values are summarized to the main invoice if they aren't already.