No prob.

>You're welcome. I noticed an error in the SELECT, where !dele should of course be, where !dele(). Sorry.
>
>>Looks good.
>>I'll give a try.
>>
>>Thanks.
>>
>>>OK. Why not do an SQL SELECT to obtain group counts on the parent table with the appropriate GROUP BY and WHERE !DELETED() to get the numbers you require into a cursor and use those cursor values in your report. For instance:
>>>SELECT groupingfield,count(*) as cnt ;
>>>from parent ;
>>>where !dele ;
>>>group by 1 ;
>>>order by 1 ;
>>>into cursor grpcount
>>>Then use grpcount.cnt appropriately in your report.
>>>This SELECT should be much faster than 25 - 30 counts.
>>>Good Luck.
>>>
>>>>Hi:
>>>>
>>>> RECCOUNT() won't work because it doesn't respect SET DELETED.
>>>> Using COUNT was my first choice but the table has over 150,000 records and the report is grouped on a field that could have at least 25 - 30 different values. Even after SELECTING filtered data into a cursor to work with a smaller set of data I still end up with about 100,000 records and more than 20 groups, so COUNT is no an option since it will take forever to count every time the group changes.
>>>>
>>>>
>>>>>Why not just use RECCOUNT('parent'), it is not affected by relations or skip? If that won't work for you just do a COUNT in parent before setting the relationship, store it in a variable and place the variable on your report.
>>>>>>Hi:
>>>>>>
>>>>>> Printing a report where I have two related tables with one to many
>>>>>> I'm having problems getting a total count of the parent table records.
>>>>>>
>>>>>> Example:
>>>>>> parent.dbf
>>>>>> field1 n(10)
>>>>>> child.dbf
>>>>>> field1 n(10)
>>>>>> field2 c(5)
>>>>>>
>>>>>> use parent order field1
>>>>>> use child in 0 order field1
>>>>>>
>>>>>> set relation to field1 into child
>>>>>> set skip to child
>>>>>>
>>>>>> DETAIL BAND
>>>>>> parent.field1 child.field2
>>>>>>
>>>>>> SUMMARY BAND
>>>>>> [the count of parent.field1]
>>>>>> [the count of child.field2]
>>>>>>
>>>>>> Because of the one to many relationship both totals are always the same.
>>>>>> If there is one record in parent for which there is 3 records in child
>>>>>> I'm supposed to get:
>>>>>>
>>>>>> Total of parent: 1
>>>>>> Total of child: 3
>>>>>>
>>>>>>but instead I get
>>>>>>
>>>>>> Total of parent: 3
>>>>>> Total of child: 3
>>>>>>
>>>>>>The count of parent.field1 increments while the pointer is moved in child.
>>>>>>I understand why this is happening, what I don't know is how to fix it.
>>>>>>
>>>>>>
>>>>>>TIA