[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] on-break problem



I am having trouble using the on=break function.  Below is an example of 
what happens.   The first 2 columns print before the on-break activates. 
This then misaligns the first printed line after the on- break.

---------------------------------------------------------------------
GII     H16     RCDC    Xxxxxx,Xxx  123456
GII     H16     RTPC    Yyyyyy,Yy  123456
GII     H16 
 
 Total EE for Age Group = 
 
CR      Gejrolfuq,Neux  300829
GII     H16     CR

---------------------------------------------------------------------

Here is the code I am using:

begin-select distinct
p2.company    ()  on-break level=1 skiplines=2 print=NEVER 
after=PrintCo_Totals save=$old_company
        let $company = &p2.company
        PRINT $company (+1,5)
p2.paygroup   ()  on-break level=2 skiplines=2 print=never 
after=PrintPG_Totals save=$old_paygroup
        let $PAYGROUP = &P2.PAYGROUP
        print $paygroup (0,+1)

a.age_range_high (0,+1) on-break level=3 skiplines=2 print=never 
before=Print1 after=Printage_Totals save=$old_age
p2.location   (0,+1)
P2.NAME       (0,+1)
ep2.emplid    (0,+1)

. . . . 
I get the same results with this code:

begin-select distinct
p2.company    (+1,5)  on-break level=1 skiplines=2 print=always 
after=PrintCo_Totals save=$old_company
p2.paygroup   (0,+1)  on-break level=2 skiplines=2 print=never 
after=PrintPG_Totals save=$old_paygroup
a.age_range_high (0,+1) on-break level=3 skiplines=2 print=never 
before=Print1 after=Printage_Totals save=$old_age
p2.location   (0,+1)
P2.NAME       (0,+1)
ep2.emplid    (0,+1)
. . . . 


Any suggestions.    I am running the sqr to a csv file  using the 
following
-il:\hr82\sqr\ -fc:\temp\xxx.csv   -Oc:\temp\xxx.LOG 
-ZIFL:\HR82\SQR\PSSQR.INI  -PRINTER:Eh -eh_csvonly

Thanks in advance for any help!
  Thanks!

Rhonda Hudgins
@}---'----,----
Genencor International, Inc
office - 585/256-5266
rhudgins@genencor.com

--------------------------------------------------------------------------
This message (including any attachments) may contain information
which is confidential or privileged. Use, dissemination, distribution, 
or reproduction of this message by unintended recipients is not 
authorized and may be unlawful. If you are not the intended 
recipient, please advise the sender immediately by reply e-mail and 
delete this message and any attachments without retaining a copy.
--------------------------------------------------------------------------

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