[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Page-break required on-break
- Subject: RE: [sqr-users] Page-break required on-break
- From: "Benzenhafer, Dave" <DBenzenhafer@houston.deepwater.com>
- Date: Thu, 21 Nov 2002 16:01:34 -0600
- List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
Try this. The at-end=new-page should do the trick for you.
Begin-Procedure Main
Columns 1 50 100
Move 40 to #bottom_line
Begin-Select
oi.ORDER_NO &po (,2)
If #current-line >= #bottom_line
next-column goto-top=1 at-end=newpage
Else
position (+1,1)
End-if
End-if
>From .........
Where.....
End-Select
End-Procedure
Dave Benzenhafer
dbenzenhafer@houston.deepwater.com
-----Original Message-----
From: D Patel [mailto:dgpinfo@yahoo.com]
Sent: Thursday, November 21, 2002 3:52 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Page-break required on-break
Hi All!
I am new to SQR reports...
I wanted to skip page whenever i finish a group. I
mean I have a column on which i have on-break. Now
whenever the value of that column change i have to
start my report from the next page.
Please guide me how to do. Reply ASAP.
Thanks in advance.
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users