Forum Discussion

HSHS's avatar
HSHS
Qrew Trainee
8 years ago

Report of many child records and parents records.

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.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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.