Forum Discussion

JeffOser's avatar
JeffOser
Qrew Trainee
25 days ago

Display Summary Table in Related Child Records

How can I display a parent summary table report in each child record?

The report, screenshot below, includes all subprojects (the child records) related to a project site (the parent). I desire this report in the child table to display the related subprojects.

4 Replies

  • OK, now I understand.

    Just make a new field on the child table of Type = Report Link,  and Let's call it [Report Link of Sibling Sub Projects] and then configure both the right and left field on the Field Properties setup to be the field for Related Parent... in your case its probably a field called [Related Project].  Watch out for a Browser pop up blocker when you go to locate the [Related Project] field on the right side.

    Make a report on the child table of Sub Projects called perhaps Used on Sub Projects.

    Then, if you are using Legacy forms put that Report Link field on the form and set the Report link field to use that report.

    If you are New Style forms, put the report on the from and set the panel to use the report link field as a filter.

  • I'm trying to understand the question.

    Let's suppose the Parent is Ben Cartwright and he has three children, being Adam, Hoss, and Joe.

    What is it that you want to display on the report of the children.  Or are you asking for the children names to be shown on the Report of parents.

     

    • JeffOser's avatar
      JeffOser
      Qrew Trainee

      Each child's record would display a report reflecting the siblings' records: Adam, Hoss, and Joe.

      Thank you!