>>>>>Were does the Report Designer read in each record?
>>>>>I want to trap for records with certain values and
>>>>>be able to skip over that record.
>>>>>any ideas? ... thanks
>>>>
>>>> why not set the filter/create the cursor before you run the report?
>>>>
>>>>Arnon
>>>
>>>Hi Arnon - I can set a filter before I run the report. I just wanted to know
>>>if the REPORT DESIGNER had a area where it reads the record and you had
>>>to option to SKIP the record depending on certain logic.
>>>.... :)
>>
>>Hi Robert, in the data environment, there is a property on the cursor (Filter)
>>You can add your condition there.
>Hi Sonny and thank you for answering. I use the filter property and it works great...
>My problem is, I need a SUMMARY page at the end of this report
>that counts duplicate fields values.
>example
>
>States Number of occurrences
>Texas 5
>New York 2
> -----------
> 7 total
>I do not no how I can trap for these fields and
>keep of count of the number of their occurrences.
>Is there a way in the report designer?
>thanks .. :)
You could base your report on an SQL statement that selects the totals for each value as well as the values themselves. Run the SQL in the report's init, store the results to a cursor, and base your report items on the fields of the cursor.
Erik Moore
Clientelligence