| 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 | 
    I'm having a problem using direct operators in a heading for my report.
    MAX., MIN., LST. are not working how I think they are supposed to.
    
    In my report heading I want to print the Highest Ship Date on the
    report (MAX.SHP_DT), but it doesn't seem to work.
    
    TABLE FILE SHIPMENTS
    HEADING
    "REPORTING OF SHIPMENTS THROUGH <MAX.SHP_DT>"
    PRINT PART_NO QTY_SHP SHP_DT
    END
    
    What I end up getting is the SHP_DT for the first record on each page
    is printed in the heading.  This is what I would get by default by
    just saying <SHP_DT>.  If I use the <MAX.SHP_DT> in a non-tabular
    format ( no detail lines printed ) it works but not in a heading on
    a detail report.  Has anyone else had this problem ?  I could swear
    I've done this type of thing before ( but the mind goes first ), maybe
    a bug with newer versions ??
    
    It says on page 2-146 of the manual ....
    "You can use ANY prefix operator in a heading or footing to perform
    specific operations."  Seems like it's supposed to work.  The example
    listed using MIN. & MAX. does not print detail lines however ;-).
    
    I have a workaround to get the right data into the headings now, just
    wanted to see if I'm alone in this problem .
    
    Sharon
| T.R | Title | User | Personal Name | Date | Lines | 
|---|---|---|---|---|---|
| 498.1 | It DOES work, honest ! | RDGE61::KEEGANP | ungry of 'orsham | Fri Mar 06 1992 03:06 | 14 | 
| Hi, Sharon,
After last Summer's embarrassment I did hesitate, but here goes !...
    TABLE FILE SHIPMENTS
    HEADING
    "REPORTING OF SHIPMENTS THROUGH <MAX.SHP_DT>"
>>> SUM MAX.SHP_DT NOPRINT
    PRINT PART_NO QTY_SHP SHP_DT
    END
regards,
Paul K
 | |||||
| 498.2 | Extra sum works | KAHALA::FOREMAN | Nothings Impossible, you just run out of time | Thu Mar 12 1992 10:20 | 10 | 
|     Paul,
    
    What you suggest does work, which is what I did in my workaround.  It
    just seems to me that the documentation suggests that it is supposed
    to work without the added sum/noprint statement.  In my humble opinion
    its either a bug in the software or the documentation.  Point
    fingers towards favorite target here .... ;-)
    
    Sharon
         
 | |||||