I have a report where there are two tables that hold info that are related to the same key field.
However, both of these tables hold multiple rows so I am having trouble figuring out how to deal with it in one sub-report (I can't do a sub-report in a sub-report, which would have been awesome).
Plus, table 1 gets displayed in details, table 2 info goes in the footer.
I was thinking to use an array. I would create the array in a formula, but I only want to add distinct values of the NAME on table 2. I then am thinking on looping through that array in the footer and displaying my values,
I am looking for some direction on the code for this, I have an idea but I am not sure how to only add distinct values into the array, how to declare the array so that the size is based on the # of distinct values, where to place the formula (I think I need to add something like whilereadingrecords right?)