SSRS 2005 - count rows when details row has a hidden expression (1 Viewer)

rkrause

Registered User.
Local time
Today, 01:07
Joined
Sep 7, 2007
Messages
343
Im using SSRS 2005, and i have a table thats getting me my correct data.
I have this in my one of my fields:
=IIF(Fields!ReceiptQuantity.Value < AVG(Fields!ReceiptQuantity.Value) -14,Fields!ReceiptQuantity.Value,"")
and in my details row in the visibiltiy i have this:

=IIF(Fields!ReceiptQuantity.Value < AVG(Fields!ReceiptQuantity.Value) -14,False,true)Im gettin my correct data but i havin trouble counting the the number of boxes that are being shown from the table
i tried this

=COUNT(IIF(Fields!ReceiptQuantity.Value < AVG(Fields!ReceiptQuantity.Value) -14,Fields!ReceiptQuantity.Value,""))
but get errors. any ideas?
 

Users who are viewing this thread

Top Bottom