Format Strings! : Used on a data-set field

[nlaliberte]

I'm using Crystal XI and an OLE DB connection to a SQL Server.

I want to know if it's possible to use a format string on a field in the data-set. I'm familiar with using a format string in a formula i.e.:
totext({table.field1},"#,###.00")

We would like to do this without having to create a formula. The actual format-string will be passed in as a field in the data-set, so basically I want to format 'field1' with 'field_format'.

'field1' = 6500.253
'field_format' = "#,###.00"
Desired Result (without using a formula) = 6,500.25

Is this possible?

 

[kskid]

If it's a number field, you can right click on the field -> Format Object and format it the way you want under the number tab.