Forum Discussion

ArshadKhwaja's avatar
ArshadKhwaja
Qrew Commander
8 years ago

Summary Report with Data rather than count

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. 
  • 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.
  • Thanks.  I suspected this.  This could be easily done in Excel and that's what I am going to recommend.