>>>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.
Steve Medvid
Systems Analyst
Environmental Resource Management