Parameter Option problem 2

[gscheepers]

Hi,

I'm having a problem with the record selection formula. I use 3 different parameter options, but when I include the second selection in the record selection formula, it ignores the criteria entered in the parameter and display all the data. when I disable the second part of the selection formula, it works fine.

This is what I have in my selection formula:

if {?Extension_Number} = 'All' then
{@CallDate} = {?CallDate}
else
{Extensions.Extn} = {?Extension_Number} and
{@CallDate} = {?CallDate};

If I disable the next part, the top formula works fine, enable it and it doesn't:

//if {?Dept_Name}='All' then
//{@CallDate} = {?CallDate}
//else
//({Departments.DepartmentName} = {?Dept_Name} and
//{@CallDate} = {?CallDate});

Any help will be wonderful!

Thanks, Gerhard Scheepers
Business Systems Manager - LETEC

 

[paulosinuk]

I'm no wiz but try nesting this 'if' statement:

If Extension Number = 'All' and Dept Name <> 'All' then
....
else
If Extension Number <> 'All' and Dept Name <> 'All' then
....
else
If Extension Number = 'All' and Dept Name = 'All' then
....
else
If Extension Number <> 'All' and Dept Name = 'All' then
....

It might be that the combination of the parameters governing the selection is the issue.

 

[dgillz]

I have never written an if-then statement with a trailing semicolon ;

Try getting rid of those and see what happens. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com