Hi Guys...

I got some trouble Using Reports


Samples Like THis..

>>> PAGE HEADER <<<
---------------------------------------------
CONDITION
---------------------------- KEY
GOOD BAD STINK
---------------------------------------------


>>DETAIL<<
---------------------------------------------
G - - 1
- B - 1
- B - 1
- B - 2
- - S 2
G - - 2
---------------------------------------------
2 3 1 >> SUBTOTAL


WHERE THE FIELD IN DETAIL RESULTING THE G, B, S, OR - IS FROM THE SAME FIELD
AND IN IT I PUT :
IIF(CONDITION='GOOD','G','-') FOR GOOD,
IIF(CONDITION='BAD','B','-') FOR BAD,
IIF(CONDITION='STINK','S','-') FOR STINK

BUT THEN I FIND SOME TROUBLE TO COUNT THE CONDITION FOR 'G' AND FOR 'B' AND FOR 'S'
I'VE FIXED IT WITH VARIABLE FROM A FORM TO HANDLE IT...

BUT THEN BECOME MORE COMPLEX AND I HAVEN'T SOLVED IT IF
THE REPORTS IS BEING GROUP BY KEY


TO BE LIKE THIS

>>> PAGE HEADER <<<
---------------------------------------------
CONDITION
---------------------------- KEY
GOOD BAD STINK
---------------------------------------------


>>DETAIL<<
---------------------------------------------
G - - 1
- B - 1
- B - 1
---------------------------------------------
1 2 0 >> SUBTOTAL


>>> PAGE HEADER <<<
---------------------------------------------
CONDITION
---------------------------- KEY
GOOD BAD STINK
---------------------------------------------


>>DETAIL<<
---------------------------------------------
- B - 2
- - S 2
G - - 2
---------------------------------------------
1 1 1 >> SUBTOTAL


HOW COULD POSSIBLE I GET THE SUBTOTAL IN THAT CONDITION COULD YOU HELP ME OUT...

N HOW TO CALL PROCEDURE FROM A REPORT ??

THANKS

REGARDS,
TUTARIE