on 05-19-2011 10:05 AM
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..
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.