3 Parameters that allow multiple values

[marydn]

Hi,

I have a report that has 3 parameters that allow multiple values. However, it doesn't seem to filter the data correctly. It seems like the report meets each individual condition and not all the conditions as a whole. I am using Crystal 9.0 and this is my formula:

If {?Site Status} = "All" Then True
Else {rspTest;1.SiteStanding} IN ({?Site Status}) AND

If {?Site Type} = "All" Then True
Else {rspTest;1.SiteType} IN ({?Site Type}) AND

If {?Lease Status} = "All" Then True
Else {rspTest;1.LegalDocumentStatusName} IN ({?Lease Status})

I am sure it is a simple fix, but my brain isn't working today.

Any help would be greatly appreciated!!!!

 

[vidru]

Try enclosing each section in parentheses:

(If {?Site Status} = "All" Then True
Else {rspTest;1.SiteStanding} IN ({?Site Status}))
AND
(If {?Site Type} = "All" Then True
Else {rspTest;1.SiteType} IN ({?Site Type}))
AND
(If {?Lease Status} = "All" Then True
Else {rspTest;1.LegalDocumentStatusName} IN ({?Lease Status}))

-dave

 

[synapsevampire]

A slight rewrite might help to assure SQL pass through:

(
If {?Site Status} <> &quot;All&quot; Then
{rspTest;1.SiteStanding} IN ({?Site Status}))
else If {?Site Status} = &quot;All&quot; Then
true
)
AND
(
If {?Site Type} <> &quot;All&quot; Then
{rspTest;1.SiteType} IN ({?Site Type}))
else {?Site Type} = &quot;All&quot; then
true
)
AND
(
If {?Lease Status} <> &quot;All&quot; Then {rspTest;1.LegalDocumentStatusName} IN ({?Lease Status})
else If {?Lease Status} = &quot;All&quot; then
true
)

-k

 

[marydn]

Vidru's code worked. I got errors with Vampire's. Anyway, it seem to work...THANKS!!!!!!!!!!!!!!!!!!!