>>>>>>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.
Hi Erik
All I need to do is to stuff a 2 dim array and dump it in the summary page.
I just don't know how to evaluate each record with code in the REPORT DESIGNER. I guess I could run the report twice. The first time to stuff the array and the second time to run the report made from the report designer and fill the summary page with the results from the array. what do you think?