I have created several sub reports that return my desired values from various tables. I would like to now 'merge' the information from the sub reports on a main report.
sub report A Sub report B Sub report C
Record 1 Record 1 Record 1
detail a detail b detail c
Main Report
Record 1
detail a
detail b
detail c
the reason for the sub reports is that the different values are in the same table and there are multiple entries in the table and I only want the latest entry. So I have sorted the desired info into the sub report, but have yet to figure out how to format on a main report.
Thanks in advance for any insight,