Discussions

Expand all | Collapse all

Report: Month over Month - Many to Many

  • 1.  Report: Month over Month - Many to Many

    Posted 04-14-2017 21:47

    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.



  • 2.  RE: Report: Month over Month - Many to Many

    Posted 04-15-2017 01:17
    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.