4 Replies Latest reply on Feb 13, 2017 6:16 AM by philmodjunk

    Report that includes child records even when no grandchild records


      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.