Ravi,
I'm still unclear on one thing ... Is each different "service" a different record in the table, or do you have several different service fields in the record? IOW, are you totally the number of records to find the number of services or are you checking several fields and counting how many are not zero?
Cathy
>Here is the scenario. The report shows clients for a given professional; services provided to the client (fee code); special overtime (premium);dollar amout for service rendered (amount) etc.
>
>I declared a report variable numbill which counts the number of clients. This works as desired. Each time a new professional is encountered, the report resets and count is also reset.
>
>Another variable docamt provides me with the dollar totals for a given professional and behaves the same as mentioned in the previous para.
>
>each client may have up to 7 services billed in a given invoice, and I want to get a count of all the services provided by a given professional. I therefore created a report variable "numofservs", which should also behave the same as the previous two. However, it keeps doing a count like that of the variable numbill - which just counts the clients.
>
>Ihope this provides you with a better picture as to what I am trying to achieve.
>
>Thank you for your interest.
>
>- Ravi