Hi,
I am working on a report that include some columns of currency. I have stored the currency symbols in database and fetching the appropriate form there.
I am not able to group numbers when I concatenate currency fields with number field.
=Fields.(DrAmount)
When I apply grouping on above field I get appropriate result i.e 15,000.
=Fields.CurrencySymbol+' '+(Fields.DrAmount)
When try this one I can't group numbers and I get the result like this. i.e Rs 15000.0000
=Fields.CurrencySymbol+' '+CDbl(Fields.DrAmount)
When try this one I get the result like this. i.e Rs 15000