Report Builder Question (string)

Thanks Todd,
That took care of it. Simplified things nicely.
Regards,
................................................................
What about using a mask in the conversion in the "Optional Format
String" space?
Such as: STRING(TRUNCATE(12345.67,0),'>>>>>')
-Todd C.
When I convert a numeric to string (for instance record count), I get a
'.00' added to the string.
When I right-trim, I loose the significant zero on the value 10, 20, 30
etc.
First of all....does anyone know how to convert a numeric to a string
without getting the 2 decimals?
I've tried using the integer fuction, but encounter the same thing.

tia,


[Non-text portions of this message have been removed]
What about using a mask in the conversion in the "Optional Format String" space?
Such as: STRING(TRUNCATE(12345.67,0),'>>>>>')
-Todd C.

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Thursday, May 05, 2005 12:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question (string)


When I convert a numeric to string (for instance record count), I get a
'.00' added to the string.
When I right-trim, I loose the significant zero on the value 10, 20, 30
etc.
First of all....does anyone know how to convert a numeric to a string
without getting the 2 decimals?
I've tried using the integer fuction, but encounter the same thing.

tia,


[Non-text portions of this message have been removed]



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]