Post reply

crystal Selection Forumla and SSRS

  • March 31, 2009 at 1:48 pm

    #384260

    i am converting crystal reports to SSRS.

    in one of the report there is a selection formula (record selection)

    InStr ({oracleview.fieldname}, {?parameter}) > 0

    Based on this condition when the parameter value is entered the records are retrieved.

    how do i implement this in the SSRS and where/

    Please let me know

  • April 1, 2009 at 1:41 am

    #969659

    Instr() is also avilable in SSRS and you can check the condition like below

    =iif(InStr(FieldName,ParameterName)>0,TrueCondition,FalseCondition)

    You can use this expression where ever you want.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply