Focal Point
How to Only print distinct rows???

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9747063336

September 10, 2013, 11:35 AM
smoss
How 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?


WebFOCUS 7.7.03M
OS/400 and the client is Win7
September 10, 2013, 11:59 AM
Rifaz
Do you mean DISTINCT records ?

If so,
TABLE FILE CAR
PRINT DST.COUNTRY CAR
BY COUNTRY
END

Thanks,
Rifaz


-Rifaz

WebFOCUS 7.7.x and 8.x
September 10, 2013, 05:04 PM
Waz
To 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



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!