Summary Report with Data rather than count

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
We have a parent projects table and a child tasks table. User need to have a a report in child table where projects are listed down at the left hand side and tasks as the column at the top with dates shown underneath each task against project. Is this something at can be achieved. 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb

Posted 10 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
Can you post a hand written picture?
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks.  It is along the lines as shown in the pic
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
I don't see a way to do that natively. 

The Summary Report type does not seem to be able to summarize dates. 

It might be possible with a whole bunch of reverse relationships to float up the task names and their dates up to the Project record, but only if the set of task names is known in advance.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks.  I suspected this.  This could be easily done in Excel and that's what I am going to recommend.