You can do this with a report variable as follows:
1. Create a report variable called nState
2. Set the expression to 0
3. Set it to SUM
4. In the On Exit expression of the Data Group Footer, place this expression: _VFP.SetVar('nState', nState + 1)
5. In the Group Footer band, where you are printing these counts, use nState as the variable!
Cathy
>I have created a report and put in 1 group to summarize per state.
>I put one field in the group as the sequential no. so I will know right away the number of states in my report by looking at the last item. The problem is that field is counting the number of record per state which give me the wrong output on that supposed to be sequential no.
>
>Total no. of record=69
>Proposed printout
>
>Item no State Buyer
>1 California 34
>2 New York 20
>3 Texas 15
>
>
>Actual printout
>34 California 34
>20 New York 20
>15 Texas 15
>
>How can I make it to work as per proposed printout?
>
>Thanks for your help.
>
>Ed