[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
Title: | FOCUS, from INFORMATION BUILDERS |
|
Moderator: | ZAYIUS::BROUILLETTE |
|
Created: | Thu Feb 19 1987 |
Last Modified: | Mon May 05 1997 |
Last Successful Update: | Fri Jun 06 1997 |
Number of topics: | 615 |
Total number of notes: | 1779 |
87.0. "Problem printing RANK on reports" by TOMCAT::METCALF () Thu Jun 30 1988 16:06
I am having a problem printing the RANK on reports when there
are more than 2019 records in the file I am reporting from. Actually,
2019 was the number of records in my last successful run; 2093
records was not successful, so I don't know exactly what # of
records first causes the problem. The problem is that the RANK stops
printing on the report as soon as soon as multiple entries are
encountered for the same rank number. Here is a small piece of
the report:
RANK Customer Number # ORDERS
---- --------------- --------
1 1111111 9999
2 1211111 900
3 2222222 674
4 3333333 600
5 4444444 584
6 5555555 129
7 6666666 75
8 7777777 40
8888888 40
9222276 31
9765342 22
etc.
Note where the rank stops printing.
It does print at the top of each new page though.
The statement used to print is as follows:
PRINT SOLDTO_CUST AS 'Customer Number' AND
DEC_COUNT AS '# ORDERS'
RANKED BY HIGHEST &COUNT_RANK DEC_COUNT NOPRINT
COUNT_RANK is input at each run of the procedure.
This appears to be a bug since it works fine for 2019 records
or less. Does anyone know if this is being fixed? Or if there
is an easy way around it without having to sort the records myself
and define my own variable for rank? Also, does anyone know where
there is a list of known bugs? Any help would be appreciated.
Thanks,
Linda Metcalf
T.R | Title | User | Personal Name | Date | Lines
|
---|