It looks like the best way for me to accomplish this is with an ssrs expression.

This one appears to be working correctly:

=(IIF((Fields!Date1.Value >= Parameters!BeginDate.Value

AND Fields!Date1.Value <= Parameters!EndDate.Value),Fields!Dollar1.Value,0)) +

(IIF((Fields!Date2.Value...

I can retrieve the results just fine, it's when I have to do the sale.DollarX summation that is a problem.

See attached screenshots.

Notice that sale.Dollar5 is $50 and the date is...

Sorry, I meant to say "columns 5 and 6", not rows.

I'll get a few screenshots soon.