You can also do this using a subreport to display just the data for those two records.
1. Create the subreport, use Table B only, link on {TableA.Proj_Id}.
2. In the subreport, create a group on {TableB.Proj_ID}. Suppress ALL sections excep the Group Footer.
3. Create a formula in the subreport. It will look something like this:
StringVar combinedAFE;
if PreviousIsNull({TableB.Proj_ID}) then
combinedAFE := {TableB.afe}
else
combinedAFE := combinedAFE + ' & ' + {TableB.afe};
combinedAFE
4. Put this formula in the group footer.
-Dell
IP Logged
