>>>>>>>>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?
>
>The report designer doesn't 'scan' records in a table like I suspect you think it does. It merely uses the records that are available to it in the DE. If you want to make counts available to the report in the DE, run your code in the init event of the report to get the counts. Example:
>Select ST, count(ST) from mytable into cursor my cursor group by ST
>If you need to fill an array, then scan this cursor, filling the array with the totals from each state. HTH

Thanks Erik - I am now clear on some things. Thanks for the
example of the Select statement. I will use it. I need this
Select statement for the SUMMARY page only. The detail lines
of the report will get data from the table in the DE. I will
need to change the DE for the SUMMARY page to the Select statement
you suggested. Can I do that?