Help with parameter plz 1

[fsreport]

Hi All
Cr 9.0
MS SQl
i have a report that has 2 parameter for selection

{?Sale_Amount}
{?Redemption_Amount}

i have these 3 formulas

@Sales
if
{TRANSACTION_HISTORY.TRADE_CLASS} = "S"
then
round({TRANSACTION_HISTORY.GROSS_AMOUNT})

@Redemption
if
{TRANSACTION_HISTORY.TRADE_CLASS} = "R"
then
round({TRANSACTION_HISTORY.GROSS_AMOUNT})

@Net
{@Sales}+ {@Redemption}

i have 1 group
contact_Id field i have in the report is Rep

i place there three formula in my detail section and created 3 summaries on the group contact_Id

here is my problem

there asking that the parameter return only the result base apond the summarised total value of the contact_id (Rep)
ex:
if the enter for ?Sales >=10000.00 and ?Redemption <=5000.00
they want the records to show only these sales

i tried this in my formula
@Rep_Sub_Tot_Sale
sum({TRANSACTION_HISTORY.GROSS_AMOUNT},contact_id)>= {?Sale}

@Rep-Sub_Tot_Redemption
sum({TRANSACTION_HISTORY.GROSS_AMOUNT},contact_id)<=
{?Redemption}

@Rep_Sub_Tot_Net
{@Rep_Sub_Tot_Sale} + {@Rep_Sub_Tot_Redemption}

on the first 2 i have no error but on the last formula
@Rep_Sub_Tot_Net
i get error
"A Boolean array is required here"

Not sure how to do this
Can someone help me plz

Thanks







fsreport

 

[lbass]

You should go to report->selection formula->group and enter:

sum({@Sales},{contact_id}) >= {?Sales} and
sum({@Redemption},{contact_id}) <= {?Redemption}

Note that this will only return those contact IDs that meet both criteria.

-LB