Need help to filter records from parameter

[42894]

Hi,

I am using CRXI.

In my report, i have 3 parameters. State, Country and Zipcode parameters.

Now i need to exclude the records where State=CA, Country=USA and Zipcode=34009.

For example,
ID Name State Country Zipcode
10 XYZ CA USA 29003
20 ABC CA USA 34009
30 LMN CA USA 34009
40 GHI NY USA 79090

Output will be like this.
ID Name State Country Zipcode
10 XYZ CA USA 29003
40 GHI NY USA 79090

i need to exclude the records where all 3 parameters match with the values in each record.

I tried nested if condition but i am not sure that will help me or not. Here 2 parameters are char and 1 parameter number so i am unable to get that.

Please help me to solve this problem.

I would really appriciate your help.

Thank you,
Aataman

 

[dgillz]

In your record selection formula:

Not (
{State}={?State} and
{Country}={?Country} and
{Zipcode}={?Zipcode}
)

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?