Pb With IIF in FR3.07

this function works in FR3.06 :

[IIF(<QExploitation."BIO_ANI_EXP">=1,'Oui','Non')]

but cause some problems in FR3.07 :

Invalid expression, overflow and the application crash...

what hapened ??

Comments

  • edited 10:28AM
    Please see the bugfix in our newsgroups, group "public.hotfixes". Or wait for 3.08.
  • edited 10:28AM
    In FR 3.08 still doesn't work following : (it worked in 3.06)

    [IIF(<frxtsml."Name">='','new',IIF(<frxtsml."Name">=<MyName>,'my new','old'))]

    Please help, L.
  • gordkgordk St.Catherines On. Canada.
    edited 10:28AM
    report engine option convert null false

    [IIF(<Customers."Addr1"> = null,'n/a',<Customers."Addr1">)]

    report engine option convert null true
    [IIF(<Customers."Addr1"> = '','n/a',<Customers."Addr1">)]

    work fine in 3.08 for me.
    you probably need a second set of [] around your second iif function.
    ;)
  • edited 10:28AM
    Yes, problem really is in second IIF function. But second [] or <> doesn't work.

Leave a Comment