>Hi,
> I have a report that contains a data grouping by field cust_id. How to count the number of group/different customer in my report using report designer instead of re-query SQL COUNT() again?
>
>thank you
Hi,
Try this.
Outside your report, define a variable lnVar = 0
Create a UDF which adds 1 to lnVar and returns an empty string
In the group footer of your report, add a firld, which uses the UDF as it's expression. Each time agroup footer is printed, the UDF will be called and 1 will be added to lnVar.