>>>>>>>>>>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?
>
>I'm not sure how you have our 'Summary' page implemented, but if it is in the same report then you don't have to change DEs, just base the the items in that band of your report on the fields in the select query. If your summary page is a separate report (maybe a better idea for simplicity's sake) then all you need in that report's DE is the select statement. I wish I could give better more insightful advice on this subject, but I have used Foxfire! for my reports ever since I started VFP, so I have never really had to learn all of the nuts and bolts of the native report designer (lucky me).

Thanks Erik - you and others have given me the answers I need
for this report. thanks again.. :)