V9 Join Calculated Field toTable?

[kyle_manuel_(Guest)]

I am converting reports from R&R5.1 dBase to SQL. We have RIPARAM() calculated fields that were previously joined to a table. Can a similar join be completed in SQL? I received the error "Calculated join field ID is no longer translatable" during conversion and had to delete the join. The calculated field still works as does the rest of the report. It^s just this one field that^s causing me a problem.____Example:____Table:__ID_NAME__----------------__1_FIRST__2_LAST____Calculated field:__RIPARAM(ID)____The report would receive the field of ID and join to the table with =. If the report received "2" from the program, it would display "LAST". There will always be a record in what I am looking at now, so no right or left outer joins or anything other than equal will be needed.____Any help?

[kfleming]

In the SQL version any join field needs to be a value that can be evaluated by the SQL engine. And it does not know what an RIPARAM() field is.____You might be able to get the there by creating the report as a User SQL report where you write the select and then enclosing the join in double brackets.____You can then replace the bracketed portion of the SELECT at runtime with an RI_REPLACE.____Kathleen__R&R Support