AnsweredAssumed Answered

Generate Filtered Report From Multiple Related Table

Question asked by wildmatt101 on Feb 24, 2014
Latest reply on Feb 24, 2014 by philmodjunk

Title

Generate Filtered Report From Multiple Related Table

Post

     I am currently building a database for a construction company and have run into difficulty trying to figure out how to generate a report that totals specific information from multiple tables. The application I created combines three departments in a construction company into one system. Each department is separate from each other and each department needs to generate a report based on expense totals, labor cost, and invoice job total. I have attached a sample of what I would like the report to look like for reference.

     I have tried using portals on a list format to filter out each expense by department, but I am unable to calculate a grand total on the bottom.

     Field that will determine which department to filter by

     Interface::Department

      

Tables

     Project_t

     Expense_t

     Invoice_t

     Labor_t

     Contact_t

Screen_Shot_2014-02-24_at_10.10.43_AM.png

Outcomes