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

    Report that includes child records even when no grandchild records

    user28097

      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.