Re: [sqr-users] On-Break Question

["Genady Sosnovsky" <genadys@ontko.com>]

in Oracle you can try the following:
    begin-select
        substr(lastname,1,1) () on-break after=start_new_page
        lastname
        firstname
    from ...
    order by 1, 2

    begin-procedure start_new_page
        new-page
    end-procedure

hope it helps

Genady
genadys@ontko.com


> I wondered if anyone had any idea how to get a report to break and start a
new page when the first letter of the lastname changes (IE. A changes to B
changes to C).  Can you do that with an ON-Break statement?
>
>
>
> NOTICE:  This e-mail is intended solely for the use of the
> individual to whom it is addressed and may contain information
> that is privileged, confidential or otherwise exempt from
> disclosure.  If the reader of this e-mail is not the intended
> recipient or the employee or agent responsible for delivering
> the message 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 immediately notify us by replying
> to the original message at the listed e-mail address.
>
> Thank you.
>
>
> _______________________________________________
> 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