>I use this command
>set filter to.....
>Count FOR alltrim(result)="Pass" To a
>Count FOR alltrim(result)="fail" To b
>
>c1 20 2
>c2 30 3
>c3 38 4
>c4 40 diffr
>c5 21
>c6 55
>c7 33
>c8 23
>c9 23
>c10 55
>
>all have diffrient pass/fail value.
>but in my report always
> pass fail
>c1 20 2
>c2 20 2
>c3 20 2
>c4 20 2
>c5 20 2
>c6 20 2
>c7 20 2
>c8 20 2
>c9 20 2
>c10 20 2
Hilmar will be back (inshallah:)
I think you would need to provide piece of code doing all these + report field expressions.
You don't need to do a series of set filter + count. Also Count command as you used places results in memory variables which you seem to named a and b (bad naming). If your report has expression as m.a and m.b they'd have scalar values from last count.
Have you tried 'select ... group by ...' ?
Cetin