>>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
>
>Would you please give a better example (use data instead of HL/CN/etc.)
>
>Thanx,
>JR

I agree...

Header Section of Report:
Project Code: 00023
Labor Codes: [X] Hired Labor [X] Contract
Total HL=2 Total CN=3

Detail Section of Report:
Act Labor Code Cost
=== ========== =======
001 HL 12.0
002 HL 1.2
004 CN 3.0
029 CN 21.0
120 CN 16.2
...

I need to figure out how to perform a count "for" a condition. I can get the total by creating a formula Count({field}) and that work fine by returning 5.
In the FoxPro report tool, I would just create a function (PRG) with some SQL code that performed the counts and then return a formatted string. Can this be done similarily in Crystal Reports? Of course, the entire report is done except for this one last item: Labor Codes in the header. I have a need specifically for just the check boxes, but an added bonus would be the counts, but they are not necessary. Is there a way to perform a Locate against the ODBC Access record set to see if there are any HL's or CN's? I am alos using the Record Selection formula to filter the data. I am not currently using any views, only real tables from a single Access database. tia... Steve