Skip to main content
Question

Report of many child records and parents records.

  • June 13, 2017
  • 0 replies
  • 15 views
I have 3 parent tables each with their own child table. We use these tables to keep track of current projects going on. I am trying to run a report to see how many of the parent and child records are open, closed, or closed late. I want these all to be shown in one graph/chart that indicates the number of items closed, open, or closed late based on each quarter.
      This topic has been closed for replies.

      It is really not practical in QuickBase to run reports or charts on multiple tables in one report.  You might consider making separate reports or charts  for each table and putting them all on one dashboard.  The provide that link to that Dashboard on say the main Dashboard  where users can click a link and instantly see all three reports "side by each".
      • MCFNeil
      • Registered
      • June 14, 2017
      May I ask the nature of the 3 parent tables?  You might be able to summarize them all up to one master table and build the report in one table, but it depends on what things are there, and if they have either a date or some other 'grouping' variable.
      Terms & ConditionsAccessibility statement