Click to See Complete Forum and Search --> : Combining Statements In A Formula


LHooker
June 28th, 2008, 11:21 PM
I'm trying to combine all records with a closed date and rejection_withdrawal date in two different columns in a table. If I run each of the below statements separately, I get 520 for for closed date and 382 for rejection_withdrawal date, but when I combine statements (as shown below), the count from the last statement is returned.

How can I combine statements in a formula to return the total count from both statment ?

{Closing_Date} = {?Closed Date}
Or
{Rejection_Withdrawal_Date} = {?Closed Date}

jggtz
June 28th, 2008, 11:45 PM
And in how many records the {Closing_Date} = {Rejection_Withdrawal_Date} ?

LHooker
June 29th, 2008, 05:07 PM
{Closing_Date} = {?Closed Date} ===> 520
Or
{Rejection_Withdrawal_Date} = {?Closed Date} ===> 382

LHooker
June 30th, 2008, 09:57 AM
I narrowed down the selection to one week. Each statement generate different records. Is this a limitation with Crystal Reports ? Has anyone experience this before ? What is the solution ? Thanks in advance ! ! !