Crystal Reports

[Guest]

I am wanting to be able to cycle through all numeric fields in a report
document and change the currency symbol where applicable. I can cycle through
the fields ok, but can't seem to find a way of setting the currency symbol.

sample code (C#):

foreach(Table MyTable in MyReport.Database.Tables)
{
foreach(DatabaseFieldDefinition MyField in MyTable.Fields)
{
switch(MyField.ValueType)
{
case FieldValueType.NumberField:
case FieldValueType.CurrencyField:
case FieldValueType.Int8sField:
case FieldValueType.Int8uField:
case FieldValueType.Int16sField:
case FieldValueType.Int16uField:
case FieldValueType.Int32sField:
case FieldValueType.Int32uField:
//Set currency symbol
break;
}
}
}