>>>>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
>
>
>I ended up creating a view for the project table with the two counts I needed since I could not calculate the values within CRW. Anyone used BRIO yet? It has been getting good press reports.

You can write SQL code into the Crystal Report, but you need the DBF ODBC driver. Just an aside. I'm glad you worked out your problem.

JR