Date Checkbox Paramater

[lthomas6]

I am using a Crystal 10 report pointing to a SQL db.

I have a report with a paramter
1..Cancelled Equity. This is a boolean checkbox parameter that is automatically set to default to false.

The selection criteria is:

({?CancelledEquity} = FALSE AND isnull{Security.CancelDate})
or {?CancelledEquity} = TRUE)

The first part before the OR is working however when selecting true, it is not. It is still pulling in records where ther canceldate is null and if it is not null.

Do I need to also put in a criteria to check if the canceldate is not null? If so, how would I alter the selection critera?

 

[lbass]

(
(
{?CancelledEquity} = FALSE AND
isnull({Security.CancelDate})
) or
(
{?CancelledEquity} = TRUE and
not isnull(({Security.CancelDate})
)
)

-LB

 

[lthomas6]

Thank you - that did the trick!

 

[lthomas6]

So if the report needed to include the cancelled equity's and also have the not cancelled equities, how would this selection critera be altered to handle that? Would this type of parameter work for this?

 

[lthomas6]

To clarify my post from above:

When user checks the checkbox to include cancalled equities, the report should pull in the cancel dates that are null as well as those that are not null.

When user uncheck the checkbox, the report should pull in only those canceldates that are NOT null.

 

[lbass]

What is the prompt text for the parameter? Let's say the parm is called {?IncludeCancelled}. Then the selection formula would be:

(
{?IncludeCancelled} = true or
(
{?IncludeCancelled} = false and
not isnull({Security.CancelDate})
)
)

-LB