linking this field to another.

[rrmcguire]

I have a field in one table, Customers which is basically a text field which contains:

443069 5/3/11 received bond pmt of 87.26 on 7/11/11


In my other table, shipments, I have a field recno, which contains the same number 443069

Is it possible to link two tables together in Crystal Reports searching for theat number in the customers table field which links to the field in the Shipments table

thanks

 

[lbass]

You could create a formula like this:

left({customers.text},6)

...and use this as a link for a subreport that uses the shipment table.

Or, depending upon your database, you could potentially create a command as your sole datasource for the report where you link the customers and shipment fields in the From clause, as in:

from customers
inner join shipments on
left({customers.text},6)=shipments.numericstring

If the shipments field is a number, you would also have to convert one of the two fields so that the datatype matches.

-LB