SQLTeam.com | Weblogs | Forums

Converting crystal report formula to SSRS expression


#1

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;