I'm trying to create a report of the top 10 salesman by their sales amounts.

I have the sales amount as the only by field, and it does show the rows in order like one would expect, but it misses quite a few salesman.

I have set a RECORDLIMIT EQ 10, and when i take that off I get a completely different arrangement, and the top 10 becomes very different.

Is a recordlimit the same as a read limit somehow?

Why not :

BY HIGHEST 10 SALES_AMOUNT

Ken

RECORDLIMIT - limit the number of records retrieved that match the selection criteria

READLIMIT - limit the number of records 'looked' at for retreival to the number specified, not related to actually matching selection.

Of course as some would point out this is documented in help text.

No recordlimit and readlimit are not the same.

Recordlimit controls output, so if 10 is the recordlimit then only 10 records will be reported (after filtering is performed) Readlimit controls the number of reads performed (regardless of filtering).

In order to accomplish what you'd like try the following:

TABLE FILE XXX
SUM AMT
BY EMP
ON TABLE HOLD
END

TABLE FILE HOLD
PRINT EMP
BY HIGHEST 10 AMT
END


Regards

in order to troubleshoot this, I added a read limit.

I have a read limit of 1000000 and a record limit of 10, so it should be showing the top 10 of the 1000000 records it's records it's reading.

WHERE READLIMIT EQ 15000000
with no recordlimit returns
10,669.17
7,016.58
3,649.05
3,263.42
3,064.00
2,693.66
2,433.86
2,415.91
2,401.57
.... and quite a few more.

but, when I add
WHERE READLIMIT EQ 15000000;
WHERE RECORDLIMIT EQ 10;
I get this...
22.48
18.04
0
0
0
0
0
-14.49
-41.66
-295.25

so how does one create a top 10 report? I used to call this a TOP N report, but when I search the webfocus website I don't find anything of consequence when I search for TOP N or top N reports.

Thanks!

This message has been edited. Last edited by: Jason K.,

sorry, didn't see k.lane's suggestion had a 10 in the by command.

That works perfectly!