Formula editor 1

[slh020]

I am new to crystal reports and I am using cr10. I have a report that displays the transactions for cleints for a specific time range. Each client is identified by a unique SID Number. I want to give the user the ability to see all the records(statements) for a specific SID Number or to view them all.Here is the formula I am using to view the specific SID Number for a client, how can I change it to view all SIDs? Can someone help....Thanks

 

[slh020]

Sorry this is the formula I am using for a specific SID number...

{?start date} < {TrustTransaction.TransactionDate} and
{?end date} >= {TrustTransaction.TransactionDate} and
{TrustTransaction.Client} = {?SID Number}..Thanks

 

[lbass]

{TrustTransaction.TransactionDate} > {?StartDate} and
{TrustTransaction.TransactionDate} <= {?EndDate} and
(
if {?SID Number} <> 0 then
{TrustTransaction.Client} = {?SID Number} else
if {?SID Number} = 0 then
true
)

You would have to add 0 as one of the parameter selection options.

-LB

 

[slh020]

Thank for all the help lbass...it worked....have a good day...