Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Reports - Displaying Records which have four or more characters

Hi Guys,

I'm pretty new to Crystal Reports and am having a few problems with what is probably a basic formula!

I am looking to display records within a field which contains four or more characters.

This is how it plays out in my head anyway:

If ({table.field}) is greater than or equal to '****' then display {table.field}

So generally if the field is greater than or equal to four characters (I'm not sure if '****' is the correct way to display this??) then display the said field.

Hopefully someone knows what angle I'm coming from.

Please help! And thanks in advance..

Former Member
Former Member replied

Right click field and select format

Opposite suppress check box click the formula icon and enter

length() < 4

This will suppress field if it has less than 4 characters

Ian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question