I have a report that shows the serial numbers of our motors for each custome line. I have this grouped by transaction number. I would like to compile each serial number on the lines in the group footer to show as followed: S/N: 114, 115, 116, 117
Any Idea how I can accomplish this? Here is how it looks on the report.
Part ID S/N
GH1 - 1,322,156
D 1133500-1 114
D 1133500-1 115
D 1133500-1 116
D 1133500-1 117