[URGENT]Display Different Currency Symbols in TfrxMemoView

tampasounds

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

gpi

Try to use

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

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

tampasounds

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