Report builder question

Yahoo Archive
1
STRING(number-fld,'>>>>.99') I think will work to stop at 2 decimals.

-Todd C

-----Original Message-----
From: paulp74us [mailto:paul.pachniak@...]
Sent: Wednesday, September 03, 2003 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report builder question.


I am working on a report and have a calculated field that would like
to have return a BLANK space if the conditions are NOT met. I made
it a "string" field so I could accomplish this, but I do not know how
to format the field so that I do not get a bunch of zeros at the end
of the numbers. I am rounding the result of the calculation to 2
decimal places and I want to line up the decimal points on the report.

The character field default format is X(10), but since the result of
the calculation could give a variety of numbers I do not know how to
set it to the length of the calculation.

Examples of output:
123.450000
12.3400000
1.23000000

What I want is:
123.45
12.34
1.23


Any help would be appreciated. Thanks!



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=244522.3707890.4968055.1261774/D=egroupweb/S=1705007183:HM/A=1595056/R=0/SIG=124p07ne0/*http://ashnin.com/clk/muryutaitakenattogyo?YH=3707890&yhad=1595056> Click Here!
<http://us.adserver.yahoo.com/l?M=244522.3707890.4968055.1261774/D=egroupmail/S=:HM/A=1595056/rand=539160009>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
I am working on a report and have a calculated field that would like
to have return a BLANK space if the conditions are NOT met. I made
it a "string" field so I could accomplish this, but I do not know how
to format the field so that I do not get a bunch of zeros at the end
of the numbers. I am rounding the result of the calculation to 2
decimal places and I want to line up the decimal points on the report.

The character field default format is X(10), but since the result of
the calculation could give a variety of numbers I do not know how to
set it to the length of the calculation.

Examples of output:
123.450000
12.3400000
1.23000000

What I want is:
123.45
12.34
1.23


Any help would be appreciated. Thanks!