linking different data types

[giggles7840]

I was told that i should link a number field to a string field. obviously that isnt working. they suggested using a cast command which again, obviouly doesnt work in Crystal. is there another way that i can link these two diffrent data types in Crystal while i convince the dbas to fix it from their end?

 

[lyanch]

The bane of my life....

I have a varchar to int link as well. I can:

a) use the view I had them make to create this link
(has two fields varcharKey, intKey), very slow
b) Write a SP
c) if there are NO parameters I can add this in the SQL statement.. but it sometimes takes several tries to get Crystal to save right.

 

[dgillz]

You can make a formula to convert your text to a number or vice-versa, then write a subreport and link on the formula field. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[synapsevampire]

A cast command may work in Crystal using a SQL Expression, unfortunately I don't think that it's processed PRIOR to the link so you couldn't link on it.

lyanch has good advice, a View is very simple to create, and will resolve this. Just suggest to the DBA's that they use CAST whilst swatting 'em on the back of the head for using different datatypes...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com