Re: [sqr-users] using the on-break statement

[Christophe CHOUX <chouxchris@yahoo.fr>]

Hi,
when I need to do that. I create a procedure call Page-Break with the fonction 
new-page in it.
and on each field I add before=Page-Break like
Account (+1,1) on-break before=Page-Break 
region (,10) on-break before=Page-Break 
store (,20) on-break before=Page-Break 
 Scott.Howser@Certegy.Com wrote:
I am having trouble using the on-break statement
I have a hierarchy of the form:
level 1 Account
level 2 region
level 3 store
If I have a query like below it will not force a new correctly, it
chops
the report up. Can someone explain how to force new pages, and create
page
breaks with the on-break command?

begin-select
Account (+1,1) on-break page=change
region (,10) on-break page=change
store (,20) on-break page=change
from ~~~
where ~~~
end-select

Thanks in advance for any help,
Scott Howser
Database Analyst
Certegy Check Services
11601 Roosevelt Blvd., TA69
St. Petersburg, FL 33716
Phone: (727) 227-2801




------------------------------------------------------------------------------
This message contains information from Certegy, Inc which may be
confidential and privileged. If you are not an intended recipient,
please refrain from any disclosure, copying, distribution or use of this
information and note that such actions are prohibited. If you have
received this transmission in error, please notify by e:mail
postmaster@certegy.com.
==============================================================================

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


---------------------------------
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Testez le nouveau Yahoo! Mail

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