Convert money to char

[terry_stjean]

In Report Studio, how can I convert a money data type field to a char.
The backend database is SQL Server.

Terry

[blom0344]

cast([somefield of type money] as char(20))

[terry_stjean]

I tried your suggestion but all I get is a 1 for the value.

Terry

[blom0344]

Did you adjust the aggregate type to none for the object?

[almeids]

When you say "money to char" do you mean you want to spell the value, like "one hundred and twenty three"?
If so you'll need to look for a database function to do this, I know Oracle has one but don't know about SQL Server.