[sqr-users] On-break (lowest level identical while level above breaks)

["Brandt, Fred" <fred.brandt@cz.nl>]

Hi,

System:
Peoplesoft 7.5 HRM
Database: MsSQL 7.0
SQR: 4.3.4

In my code I use ON-BREAK with three levels. The data is in an array and is
selected by a begin-select. In this select-statement is a WHILE-construction
to get all the
data from the array row by row.
The lowest level (level=3) in the ON-BREAK-statement can be empty (value =
"").
I will show a part of the code:

*********************************************************************
  let #idx4 = 0

begin-select loops=1  
'X'  
 WHILE #idx4 <= #ar_rs_total_records 
    get $divisie_id_rs $divisie_descr_rs $afdeling_id_rs $afdeling_descr_rs
$groep_id_rs $groep_descr_rs $emplid_rs $sex_rs #fte_rs #teller_zv_emplid_rs

    #freq_rs #noemer_zv_emplid_rs #noemer_zd_emplid_rs #teller_zd_emplid_rs
from result(#idx4)
    ar_rs_divisie_id ar_rs_divisie_descr ar_rs_afdeling_id
ar_rs_afdeling_descr ar_rs_groep_id ar_rs_groep_descr ar_rs_Emplid ar_rs_Sex
ar_rs_fte ar_rs_teller_zv_emplid 
    ar_rs_freq_emplid ar_rs_noemer_zv_emplid ar_rs_noemer_zd_emplid
ar_rs_teller_zd_emplid
  
     let #idx4 = #idx4 + 1
     
     print $divisie_descr_rs ()   ON-BREAK PRINT=never
AFTER=DIV_BREAK   LEVEL=1 SAVE=$OLD_DIV skiplines=1
     print $afdeling_descr_rs () ON-BREAK PRINT=never BEFORE=set-teller
AFTER=AFD_BREAK  LEVEL=2 SAVE=$OLD_AFD skiplines=1
     print $groep_descr_rs ()    ON-BREAK PRINT=never
AFTER=GRP_BREAK  LEVEL=3 SAVE=$OLD_GRP skiplines=1

     do compute-totals
 END-WHILE
from PS_ABS_TYPE_TBL
end-select

************************************************************************

NB: structure of the data in the array concerning the first 3 fields (i.e.
the ON-BREAK-fields) :
        divisie_descr_rs        afdeling_descr_rs       groep_descr
        div1                    afd1                    grp1
        div1                    afd1                    grp2
        div1                    afd2                    "" = <empty>
        div1                    afd3                    "" = <empty>
        div2                    afd4                    grp6
        etc.

Result for div1: totals from afd2 and afd3 will be summarized, because there
is no group-break on $groep_descr_rs.

One possibility (work-around): fill the <empty> values with a value (for
example '0' and the next empty value '1' and the next empty value '0' etc). 
In that case the BREAK will occur on the group-level (level=3).
But in the rest of the code I have to make lots of adjustments if I choose
this work-around. 
What I am looking for is a way to let SQR 'see' that when a break on a
higher level occurs, it must automatically Break there, even when there is
no break on a lower level.
Can anyone help me?

Thanks,
Fred Brandt


================================================================== 
De informatie verzonden met dit e-mail bericht is vertrouwelijk en
uitsluitend bestemd voor de geadresseerde. Indien bovenstaand e-mailbericht
niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het
e-mailbericht te retourneren aan de verzender en het origineel en eventuele
kopieen te verwijderen en te vernietigen. Gebruik van deze informatie door
anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging,
verspreiding en/of verstrekking van deze informatie aan derden is niet
toegestaan. CZ staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden e-mail, noch voor tijdige ontvangst daarvan. 

================================================================== 
The information contained in this communication is confidential and may be
legally privileged. If you are not the intended recipient of this
communication please return the communication to the sender and delete and
destroy all copies. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. CZ health
insurance is neither liable for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt. 

=================================================================== 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users