[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

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.RTitleUserPersonal
Name
DateLines