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

[skirklin@stl-inc.com]

I have used the on-break after=procedure where procedure is a procedure that
has "new-page" in it.


Sherri Kirklin
Analyst/Programmer
STL-Austin
Ph: (512) 310-5286
Fax: (512) 244-0160
skirklin@stl-inc.com


-----Original Message-----
From: Scott.Howser@Certegy.Com [mailto:Scott.Howser@Certegy.Com]
Sent: Tuesday, April 29, 2003 10:29 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] using the on-break statement



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



Confidentiality Notice: The information contained in this message is
intended only for the use of the addressee, and may be confidential
and/or privileged. If the reader of this message is not the intended
recipient, or the employee or agent responsible to deliver it to the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify the
sender immediately.

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