split data and link in subreport

[atarrqis]

Oracle and Crystal XI

I have a ship_table with field = DELIVERY.
DELIVERY may include multiple delivery #s separated by commas. i.e. 6579, 6548
On the report, I have a subreport that pulls the TRACKING_NUMBER from fedex_table. There may be multiple tracking numbers per delivery #.
I link DELIVERY to the subreport. This works fine if I have one delivery #. It will print multiple tracking numbers:
DELIVERY TRACKING NUMBER
6579 555x12
333x24

Now I need to split 6579, 6548 into 2 records and find the tracking number for each.

DELIVERY TRACKING NUMBER
6579 555x12
333x24
6548 444y77

 

[lbass]

Try linking on the delivery field, and then in the subreport, go to report->selection formula->record and change the formula to:

{fedex_table.delivery} in {?pm-ship_table.delivery}

Then group on the fedex_table.delivery field.

-LB

 

[atarrqis]

Perfect, thanks.