Using 'Maximum' function to check non-numerics

[rier]

Can anyone help with the following please?

Scenario:
A customer has various records within one table and each record has a alphanumerical status, i.e, 'A', 'P', etc.
I wish to generate a report where the highest status value for the customer is 'D'.
Ideally, I would like to say something like 'Maximum ({Table.Status})='D', but it appears that this function is only used to check numerical values. How can I check maximum letters?

Thanks

Richard

 

[dgillz]

Maximum is available for strings.

Where are you placing this formula? Is your report grouped in any way? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[rier]

I'm grouped the report by the customerID. The details section shows each customer record with the corresponding status, i.e, 'A', 'D', etc

Thanks

Richard

 

[dgillz]

You never answered my question as to where you are placing this formula. You oriringal formula would test the maximum for the entire report, not for the group.

You need to write a GROUP selection formula (not a record selection formula) like this:

Maximum ({Table.Status},{CustomerID})="D"

This will totally exclude any group that does not have a "D" as the maximum status for that customer ID from the report.

Is this what you want? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[rier]

dgillz,

You're solved the problem!. I was using
Maximum ({SmartPointStatus.OrderStatus}="D"
rather than
Maximum ({SmartPointStatus.OrderStatus},{Customers.ID})="D"

Thanks very much for you help and super-speedy response

Richard