PDA

View Full Version : Selection of Multiple record "types" - Not in a Range



Joe Coley
10-Aug-2005, 08:22 AM
Using VDF native database I have a table with records containing a single
character field "type". There are 6 valid "types". In my Crystal report, I
want the report to select records where 2 of the 6 possible "type" fields
meet predefined criteria (i.e. "Q" and "S"). These types are not sequential
therefore a range would include data not desired.

Anyone have ideas as to how best to handle this reporting they'd be willing
to share?

Sam Neuner
10-Aug-2005, 09:27 AM
Just make the selection formula an "or": {file.field} = "Q" or
{file.field} = "S".

Joe Coley wrote:
> Using VDF native database I have a table with records containing a single
> character field "type". There are 6 valid "types". In my Crystal report, I
> want the report to select records where 2 of the 6 possible "type" fields
> meet predefined criteria (i.e. "Q" and "S"). These types are not sequential
> therefore a range would include data not desired.
>
> Anyone have ideas as to how best to handle this reporting they'd be willing
> to share?
>
>
>

Jĝrgen Münster
10-Aug-2005, 04:27 PM
You may also use the IN operator like this:

{file.field} in ["Q", "S"]

Regards
Jĝrgen Münster
Dialog Consult
Denmark

"Joe Coley" <sjoec@charter.net> skrev i en meddelelse
news:I1x0M6anFHA.788@dacmail.dataaccess.com...
> Using VDF native database I have a table with records containing a single
> character field "type". There are 6 valid "types". In my Crystal report,
> I
> want the report to select records where 2 of the 6 possible "type" fields
> meet predefined criteria (i.e. "Q" and "S"). These types are not
> sequential
> therefore a range would include data not desired.
>
> Anyone have ideas as to how best to handle this reporting they'd be
> willing
> to share?
>
>
>

Garret Mott
10-Aug-2005, 07:36 PM
PMJI -

But... I go a step simpler & use:

If {file.field} in "QS" Then DoSomething

Garret

"Jĝrgen Münster" <jfm@it.dk> wrote in message
news:A$k6cJfnFHA.1112@dacmail.dataaccess.com...
> You may also use the IN operator like this:
>
> {file.field} in ["Q", "S"]
>
> Regards
> Jĝrgen Münster
> Dialog Consult
> Denmark
>
> "Joe Coley" <sjoec@charter.net> skrev i en meddelelse
> news:I1x0M6anFHA.788@dacmail.dataaccess.com...
>> Using VDF native database I have a table with records containing a single
>> character field "type". There are 6 valid "types". In my Crystal
>> report, I
>> want the report to select records where 2 of the 6 possible "type" fields
>> meet predefined criteria (i.e. "Q" and "S"). These types are not
>> sequential
>> therefore a range would include data not desired.
>>
>> Anyone have ideas as to how best to handle this reporting they'd be
>> willing
>> to share?
>>
>>
>>
>
>