Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Nov 25, 2009 2:08 am**

Hi,

I'm converting a crystal report to stimulsoft, and the report has alot of formulas in it that uses IF statements e.g.

Code: Select all

IF {Claim.ClaimType} = 1 Or {Claim.ClaimType} = 12 Or {Claim.ClaimType} = 13 Or {Claim.ClaimType} = 14 Or {Claim.ClaimType} = 15 Then
    IF {Claim.NoPassengers} = 1 THEN
        'No'
    ELSE
        'Yes'
   
ELSE
    ''

How can I convert this to be used in stimulsoft ? It is vb and not C..

Thankx

Posted: **Wed Nov 25, 2009 2:26 am**

Hi

Please use the following expression in the Text property of the StiText component:

Code: Select all

{IIF({Claim.ClaimType} = 1 Or {Claim.ClaimType} = 12 Or {Claim.ClaimType} = 13 Or {Claim.ClaimType} = 14 Or {Claim.ClaimType} = 15,IIF({Claim.NoPassengers} = 1,"No","Yes"),"")}

Also please see the following flashing tutorial:
http://www.stimulsoft.com/livedemos/Rep ... ields.html

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Create formulas

Create formulas

Create formulas