Convert Crystal Report formula to SSRS Expression

0
votes

I've checked this question, but it was asked too earlier.

I'm trying to covert crystal report formula to ssrs-expression. What could be the ssrs-expression for below example?

For example:

if(instr({?@Code},",") > 0) then
   formula = "My Text"
elseif(len({?@Code})>0) then
   formula = "FOR XYZ " + {?@Code}
end if

I need to convert it into ssrs-expression

Note: This is just an example I'm having so many complex formulas like above.

Also, is there any blog - site - link where can I find all the formulas conversion code for ssrs-expression?

1
sql-serverreporting-servicescrystal-reportsssrs-2008-r2ssrs-expression

1 Answers

1
votes

You will need something like this

=iif(instr(Parameters!Code.Value, ",") > 0; 
    "My Text", 
    iif(len(Parameters!Code.Value)>0), 
        "FOR XYZ " + Parameters!Code.Value, 
        ""
    )
)

Please also see the MSDN reference for example expressions