2014 SSRS Reports Performance issues

• cs.menni

  Grasshopper

  Points: 12

  More actions

  February 2, 2015 at 9:06 am

  #295054

  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 2014 version.

  Is expressions handling in 2008 and 2014 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.