Really, appreciate your help!
CRYSTAL 8
DB2 (back end)
This following data indicates that there were 2 checks issued.
My report shows only 1…. L
My report is grouped by STATE, ISSUED_DATE, CHECK_STATUS & CHECK
Neither count distinct or running total would work
If the check number is the same but status is diffident, the count should be reset
The count should be = 2 in this case
Is there a way to set up a formula with variables?
Something like:
Thanks all!
CRYSTAL 8
DB2 (back end)
This following data indicates that there were 2 checks issued.
My report shows only 1…. L
Code:
CHECK CHECK_STATUS ISSUED_DATE WHT_TYPE WHT_AMT AMT_NET STATE
--------- ------------ ----------- -------- ----------- ------------ ---------------
515092 V 06/10/2005 FEDM 0.00 -405.14 GA
515092 V 06/10/2005 FICA -25.12 -405.14 GA
515092 V 06/10/2005 GAS -24.31 -405.14 GA
515092 V 06/10/2005 MED -5.87 -405.14 GA
515092 P2 06/10/2005 FEDM 0.00 405.14 GA
515092 P2 06/10/2005 FICA 25.12 405.14 GA
515092 P2 06/10/2005 GAS 24.31 405.14 GA
515092 P2 06/10/2005 MED 5.87 405.14 GA
My report is grouped by STATE, ISSUED_DATE, CHECK_STATUS & CHECK
Neither count distinct or running total would work
If the check number is the same but status is diffident, the count should be reset
The count should be = 2 in this case
Is there a way to set up a formula with variables?
Something like:
Code:
Dim a As Number
If check_status = "V" then a = countdistinct (check) else
If "P2" then countdistinct (check)……
Thanks all!