3 Replies Latest reply on Feb 24, 2014 1:17 PM by philmodjunk

    Generate Filtered Report From Multiple Related Table

    wildmatt101

      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