=count (*) where (Fields!Status.Value) = 'Pending' Not sure how to do this?Mathieu Alexandre Cupryk www.omegalove.com

Hi Mathieu, You can use SSRS in-built functions like CountDistinct, CountRows, Count. Also you can add your above where clause filter at Tablix level depending on your requirement. Please let us know your feedback. Thanks KumarKG, MCTS

:=IIf(Fields!Status.Value = "Pending") take count not sure how to write this.Mathieu Alexandre Cupryk www.omegalove.com

:=IIf(Fields!Status.Value = "Pending", count(Fields!Status.Value), '') statement looks like: =iif(when statement, then, else)

=SUM(IIF(Fields!Status.Value = "Completed",1,0)) Mathieu Alexandre Cupryk www.omegalove.com