Crystal Repor Link

[TaylorTot]

I am working in CR v 8.5 with an Access DB.

Goal:
I would like to match on a contract number but only look at the first 6 characters of that field for the link.

Progress:
I have modified the FROM clause in the sql statement as follows:

Q_GM_Contract.contractcode like (left(contracts.contractnumber, 6)

Although, CR accepts the link the run time is EXTREMELY slow.

Question:
Is there a better way to link off of these two fields, using a partial match?

Thanks for your help in advance.

 

[rchandr3]

Take the left from Query and replace that field with a string formula field.

You can get the Left(string) in CR which takes lot less time...

ALL THE BEST