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.
When I apply grouping on above field I get appropriate result i.e 15,000.
When try this one I can't group numbers and I get the result like this. i.e Rs 15000.0000
When try this one I get the result like this. i.e Rs 15000