Record Selection in Crystal

Thanks Wayne and Lonnie. That did it.

Troy

----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Friday, September 21, 2001 7:09 PM
Subject: [Vantage] Record Selection in Crystal


I have a record selection puzzle for anyone. I want to grab only records that fit two specific filters.

What I have right now is:

{PartTran.TranDate} > Date (1999, 11, 07) and
{PartTran.TranType} <> "adj-cst"

This drops ALL records with a date greater than 11/07/99
and also drops all TranTypes with adj-cst.

What I WANT is to drop only those records that fit BOTH criteria. So, only drop the "adj-cst" records if the TranDate is greater than 11/07/99.

Any ideas?

Troy Funte
Liberty Electronics



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
I have a record selection puzzle for anyone. I want to grab only records that fit two specific filters.

What I have right now is:

{PartTran.TranDate} > Date (1999, 11, 07) and
{PartTran.TranType} <> "adj-cst"

This drops ALL records with a date greater than 11/07/99
and also drops all TranTypes with adj-cst.

What I WANT is to drop only those records that fit BOTH criteria. So, only drop the "adj-cst" records if the TranDate is greater than 11/07/99.

Any ideas?

Troy Funte
Liberty Electronics



[Non-text portions of this message have been removed]
When you say 'drop' do you mean exclude? In RB, I would try..

NOT ((PartTran.TranDate) > Date (1999, 11, 07) and
(PartTran.TranType) = "adj-cst")

If you mean include, try removing the NOT...

Lonnie

--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> I have a record selection puzzle for anyone. I want to grab only
records that fit two specific filters.
>
> What I have right now is:
>
> {PartTran.TranDate} > Date (1999, 11, 07) and
> {PartTran.TranType} <> "adj-cst"
>
> This drops ALL records with a date greater than 11/07/99
> and also drops all TranTypes with adj-cst.
>
> What I WANT is to drop only those records that fit BOTH criteria.
So, only drop the "adj-cst" records if the TranDate is greater than
11/07/99.
>
> Any ideas?
>
> Troy Funte
> Liberty Electronics
>
>
>
> [Non-text portions of this message have been removed]
At 07:09 PM 9/21/2001 -0400, you wrote:
>What I WANT is to drop only those records that fit BOTH criteria. So, only
>drop the "adj-cst" records if the TranDate is greater than 11/07/99.

How's about:

NOT( {PartTran.TranDate} > Date (1999, 11, 07) and {PartTran.TranType} =
"ADJ-CST" )

or - you can remove the NOT, flip the ANDs to ORs, and invert all the
comparisons, like:

{PartTran.TranDate} <= Date (1999, 11, 07) or {PartTran.TranType} <> "ADJ-CST"

-Wayne [admittedly taking over 5 minutes to recall Logic 101, but better
for it]