Re: [sqr-users] Re: On-Break Question

["Brooke Funk" <Brooke.Funk@firstfedbankkc.com>]

Thank you all for your help.  Your substr worked and I got what I needed.  I'm 
surprised I didn't think of it.


>>> genadys@ontko.com 08/13/04 09:29AM >>>
Denise,

Your comments are correct, with my example I meant just to explained an
approach.

Thanks-Genady
genadys@ontko.com 

> I agree with the way you are using substr() with the on-break, except that
you should also use print=never or it will print that character at the current
position.  Also, the column names you are selecting must start in column 1 and
not be indented, as you show them.
>
> Denise M. White
> Sr. Software Engineer
> HR/Payroll Systems
> Vicor Corporation
> ------------------------------
>
> Message: 6
> Date: Thu, 12 Aug 2004 16:21:44 -0500
> From: "Genady Sosnovsky" <genadys@ontko.com>
> Subject: Re: [sqr-users] On-Break Question
> To: "This list is for discussion about the SQR database
> reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> Message-ID: <18f301c480b2$5e4aa220$61a5a4c7@BARTICUS>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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?
>
>
>
> _______________________________________________
> 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



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