Newbie question on group totaling

[staceyn]

Hello,
I am using Visual studio 2005 to create reports against an informix ODBC datasource.
I am pretty experienced in Crystal but am just learning SSRS.

I have a report that has 2 groups and 4 parameters
The groups are sales store and sales date.
The groups are filtered by the parameter values.
I have 4 parameters, start date, end date, start store and end store.
The filters in the groups are:

store group

=fields!sl_store.value >= parameters!startstore.value and
=fields!sl_store.value <= parameters!endstore.value

date group

=fields!sl_date.value >= parameters!startdate.value and
=fields!sl_date.value <= parameters!enddate.value

I only want to show totals by store and by date.
The store is group 1 the date is group 2.

The totals by date are working fine with an expression of =sum(fields!sl_qty.value)

However in the store totals I am getting the totals for the store but for all dates.

How do I get the store totals to total for the specific store but only for the selected date range?

I have tried the following formula and get zero totals for the store:

=IIF((fields!sl_date.value >= Parameters!StartDate.value and
fields!sl_date.value <= Parameters!endDate.value),sum(Fields!sl_qty.Value),0)

I have also tried this formula but get store totals across all dates regardless of the date selected:

=IIF((fields!sl_store.value >= Parameters!StartStore.value and
fields!sl_store.value <= Parameters!EndStore.value),sum(Fields!sl_qty.Value),0)

Any help would be greatly appreciated!

Thanks,
Stacey