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.
| 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 versionsIIF(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. |
|
|
|
|
|
|
|
2014 SSRS Reports Performance issues