Linking Same Fields w/ Diff Formatting

[sopomeres]

I'm looking to link the ssn's from 2 different tables from 2 different databases. How can I link the two if the below is true:

database 1: ssn = 123-45-6789
database 2: ssn = 123456789

Any ideas?

Thanks!
Chuck

 

[synapsevampire]

That would depend upon technical information.

Since the data is not the same, it won't readily link.

Please share some basics:

Crystal version
Database/connectivity used

If you're using an Access database, go into Access and create a Query which recreates the SSN to match the formatting of the other.

-k

 

[lbass]

You could create a formula that formats the field in one database to match the other, as in the following formula {@SSN}:

replace({database1.SSN},"-","")

Or, if you are using CR 8.0, where the replace function doesn't work consistently, use:

left({database1.ssn},3)+mid({database1.ssn},5,2)+mid({database1.ssn},8,4)

Then you could use one of the databases in the main report and the other in a subreport, and link {database2.SSN} to {@SSN}.

-LB