Report of many child records and parents records.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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.
Photo of HS

HS

  • 130 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
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".
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.