MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 10:33
- Joined
- Feb 5, 2019
- Messages
- 293
Hello forumers,
Is there a way to change the currency format for currency fields in a report based on a lookup to the select currency on an order? At the moment I have a drop down to select the currency. When this goes into the report I have the data source as (an example) [CurrencySymbol]& " " & [LinePrice]
This does not show as a proper currency field as if there are no decimal places, it shows as a round number. I have added Format([LinePrice","Standard"), but this seems like a long winded way of doing it.
Is there a way I can lookup, when the report is opened, to the currency selected in my drop down and then change the field format type to suit the currency used?
~Matt
Is there a way to change the currency format for currency fields in a report based on a lookup to the select currency on an order? At the moment I have a drop down to select the currency. When this goes into the report I have the data source as (an example) [CurrencySymbol]& " " & [LinePrice]
This does not show as a proper currency field as if there are no decimal places, it shows as a round number. I have added Format([LinePrice","Standard"), but this seems like a long winded way of doing it.
Is there a way I can lookup, when the report is opened, to the currency selected in my drop down and then change the field format type to suit the currency used?
~Matt