Spaces & Zeros

[doublej0]

I have searched and have been unable to find an answer to my questions. I have two databases (neither of which I can modify) each which has an account number that corresponds to each other. The problem is one has zeros preceding the account number (i.e. 000123456789) and the other has spaces (i.e. " 123456789"). Is there a formula I can use to join these two fields together?

This is in Crystal Reports 10.

Thank you.

 

[lbass]

You could add the second database to a subreport, and in the subreport, create a formula {@acctno}:

replace({table.acctno}," ","0")

Then you can link the subreport to the main report by linking the field in the first to the formula in the second.

-LB

 

[synapsevampire]

To avoid the slower subreport route, try posting your database type.

You may find that it's best to create a Command object (Use add command), and create the SQL yourself to handle the join.

-k