Crystal Reports XI: link Contact ID to local SQL data table?

[dmcheng]

Hello.  I'm using CR XI R2 SP4 with the Salesforce 3.0 driver.  I have MS SQL 2000 SP4.  I want to create a standard report that links the Salesforce Contacts table with a table in my local SQL 2000 database - the table also contains a column with the contact ID values.  When I try to link using the Contact ID field, Crystal gives me an error "Data types are not compatible."

The ID column data type in my SQL database is CHAR(18).  Is there a type I should use to make it work with Salesforce?

Thanks
David