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

delphi formatting lazarus dbgrid elevatedb
Michael Riley - AKA Gunny picture Michael Riley - AKA Gunny · Apr 22, 2012 · Viewed 30.6k times · Source

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 or not. Before knowing about the Fields Editor, I attempted to format the data at the SQL level by using a CAST (NumericField as varchar(10)) statement inside the stored procedure. By doing so, it did not expose the DisplayFormat property inside the fields editor for this particular field.

When I removed the CAST() statement from the stored procedure, the DisplayFormat property showed up in the Fields Editor.

Answer

Uwe Raabe picture Uwe Raabe · Apr 22, 2012

You can format the DBGrid columns by formatting the underlying fields. If not done, create static fields in your dataset and then set the DisplayFormat property of the field in question to 0.00 and you are done.

Related questions

Change currency format in FastReport/Delphi

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 …

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