September 10, 2013, 11:35 AM
smossHow to Only print distinct rows???
If I only want my report to print 1 record for each employee in a table but the employee is in the table multiple times...where do I specify this?
September 10, 2013, 11:59 AM
RifazDo you mean DISTINCT records ?
If so,
TABLE FILE CAR
PRINT DST.COUNTRY CAR
BY COUNTRY
END
Thanks,
Rifaz
September 10, 2013, 05:04 PM
WazTo give to the best answer possibly, your question needs to be in context.
Rifaz has a valid answer, but there may be others.
Is this a single column, or are there other columns of data that need to be summarised ?
e.g.
TABLE FILE CAR
SUM AVE.SEATS
BY COUNTRY
BY CAR
END