If then else in Select Expert 1

[ramc2000]

I need to be able to select data based on an if then else condition. Like this:

If
{field1}= certain value
then
select records where {field2}="A"
else
select all records

How can I incorporate this logic into the select expert?

PS: I'm using CR XI and Oracle database.

 

[IdoMillet]

{field1} <> certain value OR 
({field1}= certain value AND {field2}="A")

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[ramc2000]

Thank you, that did the trick.

 

[IdoMillet]

Actually, it could be simplified to:

{field1} <> certain value OR {field2}="A"

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com