Empty string problem

[Arde]

Hi

I am using database where in the comments cell there is a string value Maintenanceorder z, if the order is maintenance and empty or random text if the order is Stock order.

In the report I need to categorize the orders by letter:
M=Maintenance order
S=Stock order

But when the comments cell is empty Crystal skips the record and don't print anything on that line.

I have tried the following:
If Left ({Srder.Comments_2},11 )="Maintenance" Then
"M"
Else
"S"

If comments cell has any value the example works. But when empty Crystal skips the line and leave it empty.

Thanks

 

[lbass]

Try:

if isnull({Srder.Comments_2}) or
trim({Srder.Comments_2}) = "" or
trim({Srder.Comments_2}) <> "Maintenance" then
"S" else
"M"

If field can be null, the null check must be first in the formula.

-LB

 

[Arde]

It works if the cell only reads Maintenance, but in the end there is number of the order i.e. Maintenance 100, Maintenance 101, ...

 

[kskid]

Modify Lbass' formula to:

if isnull({Srder.Comments_2}) or
trim({Srder.Comments_2}) = "" or
not(trim({Srder.Comments_2}) startswith "Maintenance") then
"S" else
"M"

 

[lbass]

Or if Maintenance can be anywhere in the string or in mixed case, use:

if isnull({Srder.Comments_2}) or
trim({Srder.Comments_2}) = "" or
not(ucase({Srder.Comments_2})like "*MAINTENANCE*") then
"S" else
"M"

-LB