[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
- Subject: [sqr-users] on-break problem
- From: RHudgins@genencor.com
- Date: Fri, 4 Jun 2004 13:50:34 -0400
- Delivery-date: Fri, 04 Jun 2004 12:52:11 -0500
- In-reply-to: <40C0AAFF.8F5EA3C4@umuc.edu>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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