To count the cases, which are data groups, do the following:
- Define the variable nRptCaseCnt with a value of 0, set the calculate to SUM, and Reset at end of report.
- In the OnExit expression of the Case Group Footer, put the following expression: _VFP.SetVar('nRptCaseCnt', nRptCaseCnt+1)
Cathy
>I do have the data combined into one result set. I have two report variables, nRptCaseCnt & nRptProcCnt. Their initial value is 0 and the value to store is 1. They are set to Sum. Since they are setup the same, I get the same value at the end of the report in the summary band. The value does represent the correct value for the nRptProcCnt, but not for the nRptCaseCnt.