ToastyinVA
Programmer
Crystal 8
I am using a manual running total to count unique account numbers - this works fine at the detail level. When I group by account number and place the running total in the footer I noticed my count was off. Whenever there is a record with only 1 account number to group the group footer is adding 2 to the count.
WhilePRINTINGRecords;
NumberVar RetailLeaders2;
If ( onfirstrecord OR ({IS4830_POP_REPORT_VOLUME.RTL_ACCOUNT_NO} <>
Previous({IS4830_POP_REPORT_VOLUME.RTL_ACCOUNT_NO}) )
then
(RetailLeaders2 := RetailLeaders2 + 1
else
(RetailLeaders2 := RetailLeaders2 + 0
For example
account running total at the detail
A 1
A 1
A 1
B 2
C 3
C 3
C 3
account running total at the group level (account)
A 1
B 3
C 4
Why does Crystal do this? I cannot use the Distinct count function in this report because I will need to do about 10 of them (based on different conditions) and the performance time will be terrible so I need to create manual running totals
Please Help - I've spent 4 days on this already!
I am using a manual running total to count unique account numbers - this works fine at the detail level. When I group by account number and place the running total in the footer I noticed my count was off. Whenever there is a record with only 1 account number to group the group footer is adding 2 to the count.
WhilePRINTINGRecords;
NumberVar RetailLeaders2;
If ( onfirstrecord OR ({IS4830_POP_REPORT_VOLUME.RTL_ACCOUNT_NO} <>
Previous({IS4830_POP_REPORT_VOLUME.RTL_ACCOUNT_NO}) )
then
(RetailLeaders2 := RetailLeaders2 + 1
else
(RetailLeaders2 := RetailLeaders2 + 0
For example
account running total at the detail
A 1
A 1
A 1
B 2
C 3
C 3
C 3
account running total at the group level (account)
A 1
B 3
C 4
Why does Crystal do this? I cannot use the Distinct count function in this report because I will need to do about 10 of them (based on different conditions) and the performance time will be terrible so I need to create manual running totals
Please Help - I've spent 4 days on this already!