Converting Data type in BusinessObjects 1

[striker1]

Hi all,

I'm quite new to BO. I have a question on data type conversion.
If I have an object which is defined as numeric in the universe and the database, how could I convert it to display as a character string in the report?

There seems to be only "ToNumber" function in Bo but not soemthing like "ToString" in BO.

Thanks

 

[skrandel]

You want to use the FormatNumber function. It does seem funny that FormatNumber returns a character string, but it works great. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[striker1]

Thanks very much