The "IN" keyword to select records...

[bgravi]

I need to have a formula similar to the following Sql statement
SELECT au_lname, state FROM authors state IN ('CA', 'IN', 'MD')
which is the equivalent of
WHERE state = 'CA' OR state = 'IN' OR state = 'MD'

Does Crystal Reports support this form of "IN" statement? I tried to do it but it threw an error. Since my list may have quite a few elements based on user input, it would have been nice to have the "IN" keyword, instead of using the "OR".

Thank you

 

[kenhamady]

This a Crystal "Is One Of"

The formula syntax uses square brackets:

{state} IN ['CA', 'IN', 'MD'] Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[bgravi]

It appears to be case sensitive. How can make it case-insensitive? I am setting the DataDefinition.RecordSelectionFormula value at runtime. I am using CR with VS.Net

 

[kenhamady]

Uppercase ({state}) in ["CA", "IN"] Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[bgravi]

I wish it were that simple !! The search values depend on user input. The user might enter it in lower or upper case. The data in the database is also populated by the user. So, the string match must be case-insensitive.

Thank you

 

[kenhamady]

But you are capturing the input in an application you are writing, no? So, you can convert the user selection to upper case as you build the selection formula. The upper case on the field takes care of the data side. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com