Skip to main content
Question

Summary Report with Data rather than count

  • January 10, 2018
  • 0 replies
  • 16 views

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. 
This topic has been closed for replies.

Can you post a hand written picture?

  • Author
  • Quickbase Alumni
  • January 10, 2018
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.

  • Author
  • Quickbase Alumni
  • January 10, 2018
Thanks.  I suspected this.  This could be easily done in Excel and that's what I am going to recommend.