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


Generate Filtered Report From Multiple Related Table


     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