Working with a Varchar2(2000)/ in Formula

[campbere]

I am using Oracle 8, VB 6, and CR 6.

I need to include in the selection formula the criteria conversion_msg = "Successful.", but Crystal Reports identifies the field as a memo field. I believe this is due to it being Varchar2(2000) in Oracle.

Is there a way to work around this, so I can use a restriction on conversion_msg?

 

[kenhamady]

Not in Crystal, but you might be able to create a view in Oracle that reads the first 250 or so characters of the field as another column. Report off of the view and use the new column as your criteria. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)