[URGENT]Display Different Currency Symbols in TfrxMemoView

tampasoundstampasounds US
edited 9:29PM in FastReport VCL 5
I have a report that needs to display different currency symbols in report based on what symbol is stored in database.
It can always be different symbol per row

I have a db column that stores the correct symbol per row that is needed
How may I combine with this column with the column that has the number without it blowing up ?

I have tried this and get cannot convert variant string to double error.
[ADOQuery1."Symbol"][ADOQuery1."Price"]

Also
I still need to control decimal 4 places from display format so i use %2.4f

Thanks in advance

Comments

  • gpigpi
    edited 9:29PM
    Try to use

    [<ADOQuery1."Symbol"> + Format('%2.4f', [<ADOQuery1."Price">])]

    and clear TfrxMemoView.DisplayFormat.FormatStr, set TfrxMemoView.DisplayFormat.Kind to fkText
  • tampasoundstampasounds US
    edited 9:29PM
    gpi wrote: »
    Try to use

    [<ADOQuery1."Symbol"> + Format('%2.4f', [<ADOQuery1."Price">])]

    and clear TfrxMemoView.DisplayFormat.FormatStr, set TfrxMemoView.DisplayFormat.Kind to fkText


    Thank you, I did not realize the combo in display format for each
    Clearing it on ADOQuery1."Symbol" solved the error

Leave a Comment


Home • FastReport VCL 5Comment As ...

© Vanilla Keystone Theme 2025