Print Page | Close Window

Conditional Filtering

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16254
Printed Date: 18 Apr 2025 at 7:16pm


Topic: Conditional Filtering
Posted By: cathyganda
Subject: Conditional Filtering
Date Posted: 22 Apr 2012 at 10:35pm
I super need your help!

I want to filter based on the ff:

NumberOne is equal to either one of the following: 100, 200, 300, 400

OR

NumberTwo is equal to either one fo the following:100, 200, 300, 400

AND

FieldB is equal to 888

AND

DateOne is in last full month.

i have this so far:

{A.FieldB} = "888"
and
{A.DateOne} in LastFullMonth
and
{A.NumberOne} in [100.00, 200.00, 300.00, 400.00]
or
{A.NumberTwo} in [100.00, 200.00, 300.00, 400.00]

It's not working :'( i dont know how to do "OR" in filter.

Please please help me

Thank You!


Replies:
Posted By: rkrowland
Date Posted: 22 Apr 2012 at 11:21pm 
{A.FieldB} = "888" 
and 
{A.DateOne} in LastFullMonth 
and 
({A.NumberOne} in [100.00, 200.00, 300.00, 400.00] 
or 
{A.NumberTwo} in [100.00, 200.00, 300.00, 400.00])
 
Enclosing the OR statement in brackets should fix it.
 
Regards,
Ryan.

Posted By: cathyganda
Date Posted: 22 Apr 2012 at 11:33pm
Thank you Ryan! :)


Print Page | Close Window