[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Format

Rad,
  I suggest you have received numerous suggestions and you have changed your 
question several times, I suggest at this point of obtaining a sql book for 
your environment and determining the different format structures available and 
using the one appropriate for your environment.

Tom Hins
Information Technology - Application Solutions
University of Oklahoma Health Sciences Center
P.O. Box 26901
Oklahoma City, OK  73190
Phone:(405) 271-2262 Ext. 50213
Fax: (405) 271-2352
(The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. If you 
are not the intended recipient of this message you are hereby notified that any 
use, review, retransmission, dissemination, distribution, reproduction or any 
action taken in reliance upon this message is prohibited. If you received this 
in error, please contact the sender and delete the material from any computer. 
Any views expressed in this message are those of the individual sender and may 
not necessarily reflect the views of the company.)



-----Original Message-----
From: sqr-users-bounces+thomas-hins=ouhsc.edu@sqrug.org
[mailto:sqr-users-bounces+thomas-hins=ouhsc.edu@sqrug.org]On Behalf Of
radhika reddy
Sent: Friday, September 24, 2004 9:34 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Format



I don't want decimal point

>From: Don Mellen <donm@ontko.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reporting 
>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Format
>Date: Fri, 24 Sep 2004 09:31:37 -0500 (EST)
>
>Or ...
>
>Simply use the edit mask of '000000009V999999'.  The V is an implied
>decimal point.
>
>
>On Fri, 24 Sep 2004, Murty Mirthipati Venkata Suryanarayan wrote:
>
> > I feel this is a better logic:
> >
> >     round it two decimals if required.
> >     Then multiply by 1000000
> >     Then lpad
> >
> >      What say, Radhika?
> >
> >
> > With Best Regards,
> > Murty MVS
> > Software Developer
> > *SunTrust Team*
> > JPC - 7flr; +9144-28241970 Ext:244
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Bob Stone [mailto:bstone@fastenal.com]
> > Sent: Friday, September 24, 2004 7:35 PM
> > To: 'This list is for discussion about the SQR database reporting
> > languagefrom Hyperion Solutions.'
> > Subject: RE: [sqr-users] Format
> >
> >
> > no.  i mean change the order of what the other guy said.
> >
> > multiply by 1000000 first (keeps the decimals)
> > THEN put it in an integer field
> > then pad the zeros.
> >
> > Or if you wanted just the 2 decimal places you could multiply by 100 
>first,
> > then round it, then multiply by 1000 (=6 zeros). then pad the zeros.
> >
> >
> >
> > -----Original Message-----
> > From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
> > [mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
> > Murty Mirthipati Venkata Suryanarayan
> > Sent: Friday, September 24, 2004 9:03 AM
> > To: This list is for discussion about the SQR database reportinglanguage
> > from Hyperion Solutions.
> > Subject: RE: [sqr-users] Format
> >
> >
> > We said. May be Rounding by two digits will workout
> >
> >
> > With Best Regards,
> > Murty MVS
> > Software Developer
> > *SunTrust Team*
> > JPC - 7flr; +9144-28241970 Ext:244
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Bob Stone [mailto:bstone@fastenal.com]
> > Sent: Friday, September 24, 2004 7:19 PM
> > To: 'This list is for discussion about the SQR database reporting
> > languagefrom Hyperion Solutions.'
> > Subject: RE: [sqr-users] Format
> >
> >
> > uh, put it an integer field, multiply the decimal by 1000000, and pad 
>the
> > zeros on the left?
> >
> >
> > -----Original Message-----
> > From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
> > [mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
> > radhika reddy
> > Sent: Friday, September 24, 2004 8:27 AM
> > To: sqr-users@sqrug.org
> > Subject: RE: [sqr-users] Format
> >
> >
> >
> > Thanks. I could display it that way but again my requirement has changed 
>now
> >
> > i want the decimal places also to be displayed without decimal something
> > like
> >
> > value              Output to be
> > >8989.78        000008989000000           changed to   000008989780000
> > >678              000000678000000
> > >
> > >
> > >I am writing code like this
> > >
> > >let $sal = edit($yrs,'000000009)
> >
> > how to write the code to display decimal places without decimal?
> > Thanks.
> >
> >
> >
> >
> > >From: "Murty Mirthipati Venkata Suryanarayan" <murtym@hexaware.com>
> > >Reply-To: "This list is for discussion about the SQR database
> > >reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> > >To: "This list is for discussion about the SQR database 
>reportinglanguage
> > >fromHyperion Solutions." <sqr-users@sqrug.org>
> > >Subject: RE: [sqr-users] Format
> > >Date: Fri, 24 Sep 2004 16:02:35 +0530
> > >
> > >Hi Radhika,
> > >        Hope the problem already vanished.
> > >
> > >        Else try the following:
> > >
> > >        Round the number to zero digits
> > >        Multiply the result with 1000000
> > >        Now LPad zeros with respect 15 digits
> > >
> > >
> > >       All the best..
> > >
> > >With Best Regards,
> > >Murty MVS
> > >Software Developer
> > >*SunTrust Team*
> > >JPC - 7flr; +9144-28241970 Ext:244
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >-----Original Message-----
> > >From: radhika reddy [mailto:radhika_05@hotmail.com]
> > >Sent: Friday, September 24, 2004 12:05 AM
> > >To: sqr-users@sqrug.org
> > >Subject: [sqr-users] Format
> > >
> > >
> > >Hi,
> > >
> > >      One of my fields which i want to be displayed in a txt file is of
> > >size
> > >9.6
> > >I want my field(for example salary)
> > >
> > >value              Output to be
> > >8989.78        000008989000000
> > >678              000000678000000
> > >
> > >
> > >I am writing code like this
> > >
> > >let $sal = edit($yrs,'0009')
> > >
> > >and for zeroes in the last 6 places i am giving as:
> > >
> > >let $var1 =000
> > >
> > >and i am writing into file as
> > >
> > >write 1 from $sal:9 $var1:6
> > >
> > >is this the right way?
> > >
> > >Thanks.
> > >
> > >_________________________________________________________________
> > >FREE pop-up blocking with the new MSN Toolbar - get it now!
> > >http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
> > >
> > >
> > >_______________________________________________
> > >sqr-users mailing list
> > >sqr-users@sqrug.org
> > >http://www.sqrug.org/mailman/listinfo/sqr-users
> > >
> > >
> > >DISCLAIMER:
> > >Information contained and transmitted by this E-MAIL is proprietary to
> > >Hexaware Technologies and is intended for use only by the individual or
> > >entity to which it is addressed and may contain information that is
> > >privileged, confidential or exempt from disclosure under applicable 
>law.
> > >If this is a forwarded message, the content of this E-MAIL may not have
> > >been sent with the authority of the Company. If you are not the 
>intended
> > >recipient, an agent of the intended recipient or a person responsible
> > >for delivering the information to the named recipient, you are notified
> > >that any use, distribution, transmission, printing, copying or
> > >dissemination of this information in any way or in any manner is
> > >strictly prohibited. If you have received this communication in error,
> > >please delete this mail & notify us immediately at
> > >adminchn@hexaware.com.
> > >
> > >_______________________________________________
> > >sqr-users mailing list
> > >sqr-users@sqrug.org
> > >http://www.sqrug.org/mailman/listinfo/sqr-users
> >
> > _________________________________________________________________
> > Don't just search. Find. Check out the new MSN Search!
> > http://search.msn.click-url.com/go/onm00200636ave/direct/01/
> >
> >
> > _______________________________________________
> > 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
> >
> >
> > DISCLAIMER:
> > Information contained and transmitted by this E-MAIL is proprietary to
> > Hexaware Technologies and is intended for use only by the individual or
> > entity to which it is addressed and may contain information that is
> > privileged, confidential or exempt from disclosure under applicable law.
> > If this is a forwarded message, the content of this E-MAIL may not have
> > been sent with the authority of the Company. If you are not the intended
> > recipient, an agent of the intended recipient or a person responsible
> > for delivering the information to the named recipient, you are notified
> > that any use, distribution, transmission, printing, copying or
> > dissemination of this information in any way or in any manner is
> > strictly prohibited. If you have received this communication in error,
> > please delete this mail & notify us immediately at
> > adminchn@hexaware.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
> >
> >
> > DISCLAIMER:
> > Information contained and transmitted by this E-MAIL is proprietary to
> > Hexaware Technologies and is intended for use only by the individual or
> > entity to which it is addressed and may contain information that is
> > privileged, confidential or exempt from disclosure under applicable law.
> > If this is a forwarded message, the content of this E-MAIL may not have
> > been sent with the authority of the Company. If you are not the intended
> > recipient, an agent of the intended recipient or a person responsible
> > for delivering the information to the named recipient, you are notified
> > that any use, distribution, transmission, printing, copying or
> > dissemination of this information in any way or in any manner is
> > strictly prohibited. If you have received this communication in error,
> > please delete this mail & notify us immediately at
> > adminchn@hexaware.com.
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> >
>
>-----------------------------------------------------------------------
>Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
>donm@ontko.com |  "In the beginning, there was nothing, which exploded"
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
hthttp://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


_______________________________________________
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