Nested iff not working for final subreport

• Jinxseee

  SSC-Addicted

  Points: 438

  More actions

  August 21, 2012 at 4:15 am

  #266384

  Hi,

  I am migrating a SSRS 2005 report to SSRS 2008 and have come across a problem with a nested IFF expression.

  =IIF(Rownumber("Main")=0,Nothing,

  IIF(First(Fields!ReportType.Value, "Main")= "Report1",

  IIF(First(Fields!ReportType.Value, "Main")= "Report2",

  IIF(First(Fields!ReportType.Value, "Main")= "Report3",

  IIF(First(Fields!ReportType.Value, "Main")= "Report4",

  IIF(First(Fields!ReportType.Value, "Main")= "Report5","ErrorReport"))))))

  The expression above works for all reports besides the "ErrorReport" in the else part of the expression.

  This works fine in SSRS 2005.

  Any ideas as to why this would stop working in 2008?

  Thanks,

  Jinx.

• Jinxseee

  SSC-Addicted

  Points: 438

  More actions

  August 21, 2012 at 4:23 am

  #1528021

  Problem seems to have magically disappeared when I opened and ran each subreport.:rolleyes: