>>>>>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.
>
>Sorry, just want ot double-confirm.
>
>I have 2 subgroups totals and a summary total. Does it mean that I have to do three SQL to get each of the totals to generate this report? (One SQL to get the first sub-total count of the unique records. One SQL to get the second sub-total (sum of the first sub-totals) and last SQL to get the grand total of the unique count)
>
>That is why I am quite reluctant to use SQL. I am hoping that there is a way to do it using report variables.
>
>Any clue?
IMO, SQL is normal way.
Edward Pikman
Independent Consultant