>>>Is there a way to count the number of unique document number in the report? When I use 'count', it gives me the total number of records for the group instead of total number of unique records in the group.
>>>
>>>Is there a way out?
>>
>>Select Distinct docnum From table1
>>? _TALLY
>
>Can it be done in the report writer itself? If not, I have to do SQL to find the distinct number, like what you wrote.
Do SQL.
Edward Pikman
Independent Consultant