user28097

Report that includes child records even when no grandchild records

Discussion created by user28097 on Feb 12, 2017
Latest reply on Feb 13, 2017 by philmodjunk

Table relationships:

Projects

   |

Issues (child relationship)

   |

Comments (grandchild relationship)

 

There can be zero to infinite comment records relating to an issue record.

 

Report layout is based on comments table, with a "sub-summary by issue" part to display issue record above the related comments. But if there are no comment records for an issue, the issue won't print. Do I have to create at least one (dummy) comment record for each issue, or is there another way?

 

I don't think I can use a portal for the comments based on unlimited comment records and variable length. Please correct me if I'm overlooking something obvious.

Outcomes