RE: [sqr-users] on-break problem

[RHudgins@genencor.com]

Thanks   -  I  forgot to include the a.age_range_high in the order by 
clause.


  Thanks!

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




"Bencke, Gina" <GinaBencke@forestcity.net> 
06/04/2004 03:06 PM

To
<rhudgins@genencor.com>
cc

Subject
RE: [sqr-users] on-break problem






What does the Print1 procedure look like.  Does your order by clause
include p2.company, p2.paygroup, a.age_range_high in that order?

Here is what happens when age_range_high changes
1. Execute After procedures
     PrintCo_Totals
2. Set Save variables
     $old_age = &a.age_range_high
3. Execute Before Procedures
     Print1
4 Clear higher breaks
     n/a
5  Skiplines executes
    skip two lines
6 Print - or not
    a.age_range_high does not print

The best thing you can do is to trace your print cursor movement through
the above steps.

Hope this helps, if not you can reach me Monday by replying to this
message or at home using gina@bencke.com.

Regards,

Gina Bencke

-----Original Message-----
From: sqr-users-bounces+ginabencke=forestcity.net@sqrug.org
[mailto:sqr-users-bounces+ginabencke=forestcity.net@sqrug.org] On Behalf
Of RHudgins@genencor.com
Sent: Friday, June 04, 2004 1:51 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: [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





--------------------------------------------------------------------------
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