how to conditionally get the data

Hi,

In Reporting Service, how to conditionally get the data? Let's say, I don't want the line

when the Status field is "inactive" and Eff_Date<"1/1/2006"

I conditionally hided the Visibility of this line. But when i tried to get the subtotal, this line's Quantity info still was included into the subtotal.

I tried to use the Filter box of the dataset to do it, but don't know how.

Can anybody please help me out?

Thanks a lot.

What kind of datasource are you using?