RE: Difference bet. Primary and Full procedural file.

Ron, Actually if you build your result set and use UNIONs, you can get both
the summary lines and the detail lines in the same result set. Its like
reading from 1 file and writing a report.

-----Original Message-----
From: Klein, Ron [mailto:ron.klein@acs-inc.com]
Sent: Wednesday, May 22, 2002 4:36 PM
To: 'rpg400-l@midrange.com'
Subject: RE: Difference bet. Primary and Full procedural file.

Doug,
All that needs to be done for the next break is to remove one of the 'OR'
statements.  And yes it does need to be repeated for the number of breaks
you want.

Ron

-----Original Message-----
From: Douglas Handy [mailto:dhandy1@bellsouth.net]
Sent: Wednesday, May 22, 2002 3:03 PM
To: rpg400-l@midrange.com
Subject: Re: Difference bet. Primary and Full procedural file.


Ron,

>This is sort of a standard we use in our SQLRPGLE programs

Thanks -- it is the first anybody has responded with real code.

> * Force page breaks if Sorts change.
>C                   IF        SQLSORT1 <> SVSORT1
>C                              OR SQLSORT2 <> SVSORT2
>C                              OR SQLSORT3 <> SVSORT3
>
>C                              OR SQLSORT4 <> SVSORT4
>C                              OR SQLSORT5 <> SVSORT5
>C                   EXSR      $PAGBRK

But that isn't the same functionality I was showing.  That is like naming L1
on
five different fields.  You are really only doing one level break here, when
any
of the five change.

I want five (actually I guess my sample was four)  *different* levels of
headings and subtotals.  Naturally, if only the thrid field changes
contents,
the two lower levels also must kick off subtotals etc.

Could you try again with a more complete hiearchy of break levels?  You are
showing one level of headings and zero levels of totals.

We need to have the functionality be common to both to compare methods.

Doug
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.