Parameter Not link to database field

[sjlsysprg]

I created a parameter that is not link to any field in any table. I want to use it to tell the report which selection process i want it to take. For some reason its not returning anything - it justs sits there - If I take out the IF statement and leave one of the statement there it works fine. I have the following in the Record Selection Formula:

if {?SelBasis} = "P" then

{Paid} in {?BegDate} to {?EndDate} and
else
{FromDate} in {?BegDate} to {?EndDate}


Any help is appreciated
Thanks
Suzy

 

[Hm786]

Hi,

Is that necessary to use 'and' before the else. Try taking of the 'and' it dosen't make sense to me.


Thanks,
Hamida

 

[sjlsysprg]

That a mistake Its actually w/o it. I just had several parameters and I tried to cut out some to make it clearer.
I guess I didn't do a good job there.