How do you create a parent/child report that shows all the records from the child table, organized by parent?

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

How do we create a parent/child report that shows all the records from the child table, organized by parent?

Photo of Krishna

Krishna

  • 10 Points

Posted 5 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,610 Points 50k badge 2x thumb
Just do the report off the child table and bring down any lookup fields you need from the Parent. You can make a text formula field if you like in order to have an informative heading break for your "Group By" in a table report type.
Photo of Krishna

Krishna

  • 10 Points
Thank you! Could you give me a generic example for the "text formula field to have an informative heading break for Group by" feature? Need to visualize.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,610 Points 50k badge 2x thumb
Well, I'm not sure what you data fields are from the parent, but let's say that the parent was a Project and the children were tasks.

List(" ",
"Client name: " & [Client name])
"Project Name: " & [Project Name],
"Project #: " & totext([project number]))