i have a table like this on my ssrs 2008. eg Animal Cat Dog Tiger =================== 1 x r i 2 y r i 3 x r o 4 x t p 5 z t d =================== my query woks fine but i want to go further like to display the total for Cat in my expression or parameter if can, to output the text something like this.when i select a station for each it should display. house cat has X = 3 Hotel dog T =1 Sorry for my English since this is my second language. Thanks in advance A.Vadz

Hi, Do you want to count a specific value for a specific animal in the report? For example, Cat has 3 X, 1 Y and 1 Z, and Dog has 3 R and 2 T, right? Are there three fields named Cat, Dog, Tiger? Or they are only three instances of a field such as Animal? If Cat, Do, Tiger are three different fields. You can add a row outside the row group (or the details row) below the row group(or detailws row). To count the X value for Cat, you can type the following expression in the second column of the third row: =Sum(IIF(Fields!fieldname.Value="X", 1, Nothing)) To count the T value for Dog, use the expression for the third column of the third row: =Sum(IIF(Fields!fieldname.Value="T", 1, Nothing)) HTH.Regards, Leo