Change currency format in FastReport/Delphi

delphi formatting fastreport
user2244255 picture user2244255 · Jun 7, 2013 · Viewed 14.3k times · Source

In FastReport, I want to change the format of a field that holds currency values.

Right now it uses the format %2.2n, which shows numbers as 1,234.50. I want to change this to 1.234,50 but can't seem to find a format in the Delphi documentation that would do this for me. Does a format with this purpose exist or do I have to build a whole new field using FormatFloat?

Answer

bummi picture bummi · Jun 7, 2013

You are not limited to the defaults you can use FormatStr e.g with $ ###0.00 and change DecimalSeparator and ThousandSeparator as you like.

enter image description here enter image description here

Related questions

How to Format a DBGrid Column to Display Two Decimal Places?

I would like to format specific cells to force two decimal places. The data is coming from an ElevateDB stored procedure and hooked into a TDataSource. EDIT: SQL Programming Note: I wasn't sure if this was just an ElevateDB issue …

Read More
How do I pretty-print JSON in Delphi?

I am looking for a function that will take a string of JSON as input and format it with line breaks and indentations (tabs). Example: I have input line: {"menu": {"header": "JSON viewer", "items": [{"id": "Delphi"},{"id": "Pascal", "label": "Nice …

Read More
Delphi - how do you format a real number with leading zeros?

I need to format a real number with leading zeros in the whole number part prior to the decimal point. I know how to achieve this with integers, but the syntax for reals escapes me. Number := 1.234 ; SNumber := Format ('%2.3f', […

Read More