Record selection not working

[busi1]

Hi,

I have 5 parameters
1) OwnerName
2) Offerings
3) from date
4) to date
5) status

All the parameters should be optional except from date and
to date.

These are the conditions how i select the parameters

1) name, from date and to date
2) offering, from date and to date
3) status, from date and to date
4) name , offering,from date and to date
5) name, status, from date and to date
6) offering, status, from date and to date
7) from date and to date

Here is the record selection formula i wrote.
Its works for some condition but not all

Its not working for
1) name, from date and to date
2) offering, from date and to date
3) status, from date and to date


{A.Org Class}<>"Mark" and
(if ({?Owner})="None" and ({?Offering})="None" and
({?Activity Status})="None" then
{A.BEGIN_DATE} in {?From} to {?To}
else
if {?Owner}="None" then
{A.Offerings}={?Offering} and
{A.Status}={?Status} and
{A.BEGIN_DATE} in {?From} to {?To}
else
if {?Offering}="None" then
{A.last name}={?Owner} and
{A.Status}={?Status} and
{A.BEGIN_DATE} in {?From} to {?To}
else
if {?Status}="None" then
{A.last name}={?Owner} and
{A.Offerings}={?Offering} and
{A.BEGIN_DATE} in {?From} to {?To}
else
{A.Status}={?Status} and
{A.last name}={?Owner} and
{A.Offerings}={?Offering} and
{A.BEGIN_DATE} in {?From} to {?To}
)

i am using crystal v 10.0 and oracle 9
can anyone help me out?
Thanks

 

[lbass]

If you are just trying to make them optional, then try:

{A.Org Class}<>"Mark" and
{A.BEGIN_DATE} in {?From} to {?To} and
(
if {?Owner}<> "None" then
{A.last name}={?Owner} else
if {?Owner}= "None" then
true
) and
(
if {?Offering} <> "None" then
{A.Offerings}={?Offering} else
if {?Offering} = "None" then
true
) and
(
if {?Status} <> "None" then
{A.Status}={?Status} else
if {?Status} = "None" then
true
)

Note that in your example you showed the parameter for status two different ways.

-LB

 

[busi1]

Thanks Ibass,