[sqr-users] RE: on-break problem

["Ed Kelly" <ed_kelly@hotmail.com>]

In looking at your original code, there appears to be a minor issue with 
your print coordinate.  In your first example, you use (0,+1) for your 
position coordinates following the level 2 break:


        let $PAYGROUP = &P2.PAYGROUP
        print $paygroup (0,+1)


If the after procedure, PrintPG_Totals, includes any print statements, your 
cursor position will have moved and the printing of the paygroup information 
in the next detail line will be relative to where that previous print 
statement left off. I'm just guessing, but I bet one of the last commands in 
the after procedure advances the line position, and at the same time moves 
the cursor back to column 1.  For example:

        Print ''  (+1,1)

or

        Position (+1,1)

So when control returns from the after procedure, it starts printing 
relative to column 1.  This the first detail line after the break is shifted 
way over to the left.  If I am correct in these assumptions, then an easy 
correction for this is to use a fixed position for the paygroup column 
coordinate.  For example:


        let $PAYGROUP = &P2.PAYGROUP
        print $paygroup (0, 32)   ! explicitly move cursor to column 32 
before printing paygroup


Where the number 32 indicates the column position where all paygroup 
information should be printed.


I hope this is helpful.



------------------------------------------------------
>From: <RHudgins@genencor.com> Reply To: "This list is for discussion about 
>the SQR database reportinglanguage from Hyperion Solutions." 
><sqr-users@sqrug.org> To: "This list is for discussion about the SQR 
>database reporting languagefrom Hyperion Solutions." <sqr-users@sqrug.org> 
>Subject: [sqr-users] on-break problem Sent: Friday, June 4, 2004 5:50 PM 
>MIME-Version: 1.0 Precedence: list In-Reply-To: 
><40C0AAFF.8F5EA3C4@umuc.edu> Message-ID: 
><OFDC9400CF.F2C515CB-ON85256EA9.00614213-85256EA9.00620C10@genencor.com> 
>Message: 5 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
>

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! 
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/


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