Looking for records with lengthy entries in a given field 1

[mbrayc]

Hello all,

I am working on a Crystal Report (using Crystal XI R2) to attempt to locate certain parts in our database with lengthy notes. This report accesses two ODBC tables: Part_Master and Windows_Notes, which are linked such that the PRTNUM_01 (Part Number) field for each part in the Part_Master table is linked to an identical value in the KEY_61 field in the Windows_Notes table. The part notes are stored in the NOTES_61 field in the Windows_Notes table. I am looking for parts where the number of characters in NOTES_61 field exceeds a certain value (say, 50 characters). Any suggestions on how to set up a selection formula?

Thanks in advance.

 

[briangriffin]

length({NOTES_61}) >= 50

If you're not comfortable modifying the selection command directly, you could create a formula:

{@Length}

length({NOTES_61})

Then the Select Expert would include that formula in the dropdown, and you would change it to "is greater than or equal to" your value.

 

[mbrayc]

That did the trick. Thank you so much.