Converting crystal report formula to SSRS expression

• vigneshlagoons 51204

  Old Hand

  Points: 354

  More actions

  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;

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  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