Hi John,

We have had to do similar before.

What we do is create a hidden computed field on the row for each of the statuses.  Simply set the value to 1 or 0.

i.e.

c_zero, c_one, c_two, etc...

if Status is 0 then set the value of c_zero = 1 else 0, something like this if(statuscode = 0,1,0).  Use the same logic for each of the computed fields and their corresponding statuscode.

Finally in the Summary or Footer of your Grid, simply sum the values in the computed field.  "Sum(c_zero) for all"

Hope that helps.

Michael

I've done something similar on occasion to what Michael proposes, with a slight variation:

Add the hidden computed fields containing the "If" statement, one for each status value as Michael describes. Then instead of adding computed fields in the Summary or Footer bands to display the summed count of each status value (which changes the DataWindow), add a tooltip for the the status column that displays all of the summed counts, such as:

'Counts:~r~n' + 0: ' + string(sum(c_zero for all)) + '~r~n' + '1: ' + string(sum(c_one for all) + '~r~n' + .....

HTH

John

you don't have to add anything except the display in the summary band:

'total status 1 = ' + sum( if( status = 1, 1, 0) for all)   

'total status 2 = ' + sum( if( status = 2, 1, 0) for all) 

...

for your various counts