[URGENT]Display Different Currency Symbols in TfrxMemoView

tampasoundstampasounds US
edited 8:34AM 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 8:34AM
    Try to use

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

    and clear TfrxMemoView.DisplayFormat.FormatStr, set TfrxMemoView.DisplayFormat.Kind to fkText
  • tampasoundstampasounds US
    edited 8:34AM
    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

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport VCL 5Comment As ...

© Vanilla Keystone Theme 2024