>Anyone use totals in the header of a CRW form. Here the layout I'm looking for...
>
>Header: Total CN: 3 Total HL: 2
> ...
>
>Detail: CN
> CN
> CN
> HL
> HL ...
>
>I know in VFP I would just write a little function to perform an SQL count on the values. But, what can you do in CRW? The functions seem limited for using detail total values in the header section. I considered using a sub-report in the header somehow, but I have not tried it yet. Any info is appreciated. tia. Steve
Hi Steve.
You should use formula field for each total and put count(fld) function in this field:
count({database.CN}) and
count({database.HL})
Alex