At 02:18 PM 11/6/2014, Jan Johansen wrote:
Almost everyone in my industry has relegated themselves to using
spreadsheets because of this display issue problem.
But, I remain convinced that there is a way to do this in R:BASE.
Jan,
Yes, there are so many coooooooool ways to do anything in R:BASE!
(you just have to have the passion and positive attitude ...)
Here's how ...
While in Report Designer, simply change the "Display Format" of that
specific DB/VAR label 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.
Technically, for scientific notation ...
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.
That's all there is to it!
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!
--
