2013 SSRS Reports Performance issues

Hi All,

After upgrading 2008 reports to 2013 i observed there is performance lag in 2013 ssrs reports,

2008 reports which used to render in <2 secs now taking >50 secs,

After doing some checks on why this lag occurred, i found that this is because of the expressions in reports, If i remove all the expressions then report renders < 2 secs otherwise its taking >50 secs 

My question here is, we used the same expressions in 2008 version also which displays the report in <2 secs but why same thing taking more time in 2013 version.

Is expressions handling in 2008 and 2013 different.

and below are the expressions used in the both the versions

IIF(ISNOTHING(Fields!Comp.Value),"-",Fields!Comp.Value) 

IIF(ISNOTHING(Fields!Base.Value),"-",Fields!Base.Value)

IIF(ISNOTHING(Fields!Var.Value),"-",Fields!Var.Value)

iif(Fields!check.Value=true,"yellow","Transparent")

Thanks in advance 

Chandra.

 

 

February 2nd, 2015 4:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics