Post reply

Converting crystal report formula to SSRS expression

  • December 15, 2016 at 3:29 am

    #324051

    Hi,

    I have a formula in crystal report which I need to convert them to an equivalent SSRS expression.

    Since I am a newbie in SSRS, can anyone suggest me how this can be written in an expression.

    Formula:

    local stringvar val := "";

    local stringvar place := "";

    local stringvar build := "";

    if not isnull({StoredProcedure.BuildName}) then

    if trim({StoredProcedure.BuildName}) <> "" then

    (

    build := {StoredProcedure.BuildName};

    val := trim({StoredProcedure.BuildName});

    );

    if not isnull({StoredProcedure.Location}) then

    if trim({StoredProcedure.Location}) <> "" and trim({StoredProcedure.Location}) <> build then

    (

    if val <> "" then val := val + " / " + {StoredProcedure.Location} else val := {StoredProcedure.Location};

    place := {StoredProcedure.Location}

    );

    if {StoredProcedure.Record} = "I" then

    if not isnull({StoredProcedure.Park}) then

    if trim({StoredProcedure.Park}) <> "" and trim({StoredProcedure.Park}) <> place and trim({StoredProcedure.Park}) <> build then

    if val <> "" then val := val + " / " + {StoredProcedure.Park};

    val;

  • December 15, 2016 at 9:40 am

    #1918234

    It looks like you're concatenating the BuildName, Location, ... putting a slash (/) between the names if they are different. Take a look at the IIF(), ISNOTHING() and SWITCH() functions for starters and the concatenation operator (&).

    HTH,

    Rob

    https://msdn.microsoft.com/en-us/library/ms157328.aspx

    https://msdn.microsoft.com/en-us/library/dd255271.aspx

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

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