Friday, November 7, 2014
Tip of the Day: Using Scientific Notation for Display Format
Product.: R:BASE eXtreme 9.5 (32/64)
Build...: 9.5.4.30930 or higher www.rupdates.com
Section.: Report Designer
Keywords: Display Format
While in Report Designer, you may leave the default format of any underlying
data type, or you may customize the display format of all data-aware controls
as follows:
Report Designer | Select Appropriate Control | Right-Click | Display Format
For controls with numeric data types in R:BASE eXtreme 9.5 (64), such as,
INTEGER, REAL, CURRENCY, DOUBLE, NUMERIC, and BIGNUM, notice the following
available options:
#,0;-#,0
#,0.00;-#,0.00
#,0.00;(#,0.00)
$#,0.00;($#,0.00)
$#,0.00;-$#,0.00
$#,0;-$#,0
$#,0;($#,0)
0 %
0.00 %
You may overwrite the display format and further customize, if you wish.
Did you know that you can customize the Display Format for Scientific
Notation?
Here's how ...
Use the Display Format as follows:
##,E+00
Where ...
## should be for the significant number
00 is the number of digits to be displayed after the E.
Note:
To not show a '+', use "##,E-00".
A sign will only be displayed if exponent is negative.
If any of the strings "E+", "E-", "e+", or "e-" are contained in
the Display Format string, the number is formatted using scientific
notation.
A group of up to four "0" characters can immediately follow the "E+",
"E-", "e+", or "e-" to determine the minimum number of digits in the
exponent. The "E+" and "e+" formats cause a plus sign to be output
for positive exponents and a minus sign to be output for negative
exponents.
The "E-" and "e-" formats output a sign character only for negative
exponents.
Have fun!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
