Join String to Number

[IanWaterman]

CR 10 Oracle 8

In CR 8.5 you could join two tables where one contained a numeric string and the other a number. (Our illustrious developers have stored a supplier key as both numbers and numeric strings in different tables).

A number of reports were developed in 8.5 when this was OK, crystal would complain but allow the join and bring back the correct data.

We recently upgraded to 10, the old reports run fine in 10, but we now have a new requirement (I can not modify an old report) where I need to make such a join in CR10.

CR10 just refuses to make the join, I have looked in the Registry but can not see anything to turn on or off there which may help.

Any help will be greatly appreciated, I can make a view of the data and convert to a number, but would prefer not to do that(but will as a last resort), neither can I force the development team to build tables consistently.

Thank you

Ian

 

[synapsevampire]

After dousing the Oracle dba's in kerosene, go ahead and create the View. This should serve as the only access to the table going forward.

Now, fire the dba's proper likes.

Recreating the table correctly should only take a few minutes, and if a dba balks at that, you have the wrong dba.

If you have application programmers designing tables, you have the wrong management.

-k