Linking views

[biggerV]

I am trying to link 2 views in a Crystal Report using Crystal Reports 10 and an Oracle Database. The problem I am having is that in one of the views the field to be linked is stored as a number, in the other view the field is stored as a string (for some unknown reason). When I attempt to link these 2 views on this field, I understandably get a Data types are not compatible error. Is there any way to work around this without creating a new view with the correct data format? Thanks in advance.

V

 

[lbass]

You could add one view in a subreport where you convert the field to match the datatype of the corresponding field in the main report. Then use this formula to link to the field in the main report.

-LB