Discussions

Expand all | Collapse all

Report of many child records and parents records.

  • 1.  Report of many child records and parents records.

     
    Posted 06-13-2017 17:55
    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.


  • 2.  RE: Report of many child records and parents records.

    Posted 06-13-2017 18:57
    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".


  • 3.  RE: Report of many child records and parents records.

    Posted 06-14-2017 03:34
    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.