Summary Report with Data rather than count

  • 0
  • 1
  • Question
  • Updated 2 years 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,152 Points 3k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Can you post a hand written picture?
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks.  It is along the lines as shown in the pic
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,152 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.