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:



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.