Add "US$" before the number
Dear,
The following is my invoice report:
Sub Total : 117
Shipping Charges: 30
Total: 147
I want to show the "US$" before the number. If the number is NULL. It will not show anythinks.
e.g 1: Sub Total : US$117
Shipping Charges: US$30
Total: US$147
e.g 2: Sub Total : US$230
Shipping Charges:
Total: US$230
How to do this? Pls help!
The following is my invoice report:
Sub Total : 117
Shipping Charges: 30
Total: 147
I want to show the "US$" before the number. If the number is NULL. It will not show anythinks.
e.g 1: Sub Total : US$117
Shipping Charges: US$30
Total: US$147
e.g 2: Sub Total : US$230
Shipping Charges:
Total: US$230
How to do this? Pls help!
Comments
you can add a script directly in the memos.
begin
memo := '';
if [MyTable."Field"] >0 then memo := 'US$'+[MyTable."Field"];
end;
Pierre