negative numeric fields with a $#,0;-$#,0 display format show with brackets

rbuser

I am using a DBText field in a report assigned to a float field from the
data pipeline.

If I use the following display format

$#,0;-$#,0

it shows negative value fields in brackets as if the display format is

$#,0;($#,0)

for example -1500.00 displays as (1500.00)

thanks
Cameron

nardmoseley

---------------------------------------------
Article: Currency Formatting in ReportBuilder
---------------------------------------------

Currently when formatting currency display formats, ReportBuilder internally
calls FloatToStrF with a ffCurrency paramter.

This honors the Windows currency settings.

There are two ways to override this behavior:


1. Create a descendant of TppDisplayFormat.

See ppDisplayFormat.pas. YOu can easily create a descendant of
TppDisplayFormat and specify that your TmyDisplayFormat be used by
ReportBuilder to perform formatting. See the initialization section
ppDisplayFormat.pas.

2. Override the Window currency values

You can override this by setting Delphi's global variables for
DecimalSeparator and CurrencyString. You will probably want to restore these
values after printing the report.

Below is a simple example:

var
lcSaveDecimalSeparator: Char;
lsCurrencyString: String;

begin

lcSaveDecimalSeparator := DecimalSeparator;
lsCurrencyString := CurrencyString;

DecimalSeparator := '.';
CurrencyString := '$';

try
Report.Print;
finally

DecimalSeparator := lcSaveDecimalSeparator;
CurrencyString := lsCurrencyString;
end;


end;



For the end-user solution you may to code an event-handler
for the Report.Template.OnLoadEnd event to setup the proper settings.


--
Tech Support mailto:support@digital-metaphors.com
Digital Metaphors http://www.digital-metaphors.com


--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com