The articles in this section of the Knowledge Base involve Text Formatting for display in your reports. To learn more about Text Formatting and how to access this section within the Report Designer, see Understanding Text Formatting in the Report Designer. This article focuses on the Currency Format tab of the Text Formatting window.
The Currency Format is used to display numeric values as currency. This format was designed with the intent to output monetary values only.
Product
|
ProductID
|
CategoryID
|
UnitPrice
|
1 Door Base
|
1.0
|
1.0
|
50.00
|
2 Door Base
|
2.0
|
1.0
|
75.00
|
1 Door Upper
|
3.0
|
2.0
|
50.00
|
2 Door Upper
|
4.0
|
2.0
|
75.00
|
1 Door Diagonal Corner Base
|
5.0
|
3.0
|
75.00
|
Apply the Currency Format to the UnitPrice column.
Product
|
ProductID
|
CategoryID
|
UnitPrice
|
1 Door Base
|
1.0
|
1.0
|
$ 50.00
|
2 Door Base
|
2.0
|
1.0
|
$ 75.00
|
1 Door Upper
|
3.0
|
2.0
|
$ 50.00
|
2 Door Upper
|
4.0
|
2.0
|
$ 75.00
|
1 Door Diagonal Corner Base
|
5.0
|
3.0
|
$ 75.00
|
There are disadvantages to both of these methods of determining the mask, but there is a third option. The local settings can be used to change any parameter format. Set the value of the parameter after you’ve set the flag next to it.
Change the values for the Currency Symbol and Positive Pattern in the example above. Local settings determine other parameters.
Product
|
ProductID
|
CategoryID
|
UnitPrice
|
1 Door Base
|
1.0
|
1.0
|
€ 50.00
|
2 Door Base
|
2.0
|
1.0
|
€ 75.00
|
1 Door Upper
|
3.0
|
2.0
|
€ 50.00
|
2 Door Upper
|
4.0
|
2.0
|
€ 75.00
|
1 Door Diagonal Corner Base
|
5.0
|
3.0
|
€ 75.00
|