Discussions

Expand all | Collapse all

Summary Report with Data rather than count

  • 1.  Summary Report with Data rather than count

    Posted 01-09-2018 22:21
    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. 


  • 2.  RE: Summary Report with Data rather than count

    Posted 01-09-2018 22:30
    Can you post a hand written picture?


  • 3.  RE: Summary Report with Data rather than count

    Posted 01-09-2018 22:36
    Thanks.  It is along the lines as shown in the pic


  • 4.  RE: Summary Report with Data rather than count

    Posted 01-09-2018 23:00
    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.


  • 5.  RE: Summary Report with Data rather than count

    Posted 01-09-2018 23:01
    Thanks.  I suspected this.  This could be easily done in Excel and that's what I am going to recommend.