I am looking to create a report that includes a parent table and multiple child tables.
I have grouped the parent table by the system ID and subsequently grouped the child tables by their system ID.
I Do Not want to use sub-reports.
The child table data replicates for each entry. How can this be corrected with formulas and/or parameters?
I do not want to use the suppression formula of "{table.field}=previous{table.field}
Sample Data -
Parent table Data
Child table1 Data1
Child table2 Data1
Child table2 Data2
Child table1 Data2
Child table2 Data1
Child table2 Data2
Child table1 Data3
Child table2 Data1
Child table2 Data2
Goal -
Parent table
Child table1 Data1
Child table1 Data2
Child table1 Data3
Child table2 Data1
Child table2 Data2