Conference ilbbak::ibi_focus

192.0. "Indexed file reports/occurs" by TOLKIN::HOLLOCHER (The Children, They Were Learnin') Thu Mar 30 1989 12:19

    
    I have run into a reporting problem using an indexed file as input.
    I really don't want to put this into a FOCUS file format if it can
    be helped.
    
    The .MAS looks something like this:
    
    FILENAME=DATAFILE   ,SUFFIX=ISAM,$                ,$
    SEGNAME=ROOT                                      ,$
      GROUP=PRD_KEY  ,ALIAS=KEY  ,USAGE=25            ,$
        FIELDNAME=PRODUCT     ,USAGE=A25  ,ACTUAL=A25 ,$
    	FIELDNAME=DATA1       ,USAGE=A10  ,ACTUAL=A10 ,$
    SEGNAME=SEG2    ,PARENT=ROOT     ,OCCUR=5         ,$
        FIELDNAME=ALPH_DATE   ,USAGE=A8   ,ACTUAL=A8  ,$
        FIELDNAME=DATA_FLG    ,USAGE=A3   ,ACTUAL=A3  ,$
    
    (Note that the 5 ALPHA_DATES are the same in each record.
    
    Now I want to table the file like:
    
        TABLE FILE DATAFILE
    	PRINT DATA_FLG
        ACROSS ALPHA_DATE
    	BY PRODUCT
    	END
    
    What happens is that it does the ACROSS and the BY just fine.  But
    the PRINT of DATA_FLG makes the report look like:
    
    PRODUCT-1     DATE-1    DATE-2    DATE-3    DATE-4   DATE-5
                   YES        .         .          .       .
                    .        YES        .          .       .
                    .         .        NO          .       .
                    .         .         .         NO       .
                    .         .         .          .      YES
    
    The '.' is simply nodata and the YES/NO is what is contained in
    the field DATA_FLG.  Is there any way to put these on one line
    for each row sort?
    
    Thank You
    
     
       

    
    I figured this one out.  I created a define field appending all
    of the OCCURS fields together.  Then I sort across by the appended
    header.