Sage 100

The ""TrackingNumbers"" field in SO_InvoiceWrk does not display all tracking numbers, so I'm trying to create a field that shows them horizontally. Added a sub-report to the invoice (based on SO_InvoiceTracking), but not sure how to create the field. Any suggestions?

Add a formula to the details section of your subreport like AssembleTrackingNos: shared stringvar TrackingNos; TrackingNos:=TrackingNos+{SO_InvoiceTracking.TrackingID}+"" ""; Then add a formula to your subreport footer like DisplayTrackingNos: shared stringvar TrackingNos; TrackingNos Hide the details section. You probably should also reset this sharedvar on the subreport header with a formula like ResetTrackingNos: shared stringvar TrackingNos:=

@MichaelNottoli Thanks! I ended up using the AssembleTrackingNos formula field, added group based upon invoice # and put TrackingNos field (with AssembleTrackingNos as formula) in the group footer. Works well.

Glad it works for you. You may want to add a formula in the Group Header like ResetTrackingNos: shared stringvar TrackingNos:="""" This will prevent the shared value from bringing in data from other invoices.

Thanks. Did that as well, although I didn't make it a shared variable. For some reason, it was duplicating the last tracking number when defined as shared.