Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 2014 SSRS Reports Performance issues

Author  Topic 

chandram
Starting Member

2 Posts

Posted - 2015-02-03 : 01:51:45
Hi All,

After upgrading SQL 2008 reports to SQL 2014 i observed there is performance lag in 2014 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 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.
   

- Advertisement -