IIF error

starhustarhu
edited 3:24PM in FastReport 4.0
Hello,

I have the following memo:

[IIF( <frxMydataSet."conversionNo"> =1, [SUM( <frxMydataSet."RemainingNumber">*<frxMydataSet."Price">
,MasterData1) ] ,[SUM( <frxMydataSet."RemainingNumber">*<frxMydataSet."Price">/100
,MasterData1) ])]

... and it gives the error: Could not convert the variant of type (array variant) into type (OleStr).


Thank you in advance

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 3:24PM
    try replacing the internal [] sets with () there should only be 1 overall set of [] braces
  • starhustarhu
    edited 3:24PM
    gordk wrote: »
    try replacing the internal [] sets with () there should only be 1 overall set of [] braces

    Thank you very much! It works! >

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 4.0Comment As ...

© Vanilla Keystone Theme 2025