IIF one field ="this" then display this field question?

• thomashohner

  SSCrazy Eights

  Points: 9856

  More actions

  January 17, 2015 at 10:18 am

  #397888

  Hello, I'm building a very complex dashboard and I am having trouble with some of the expressions in SSRS. I am trying to display a value in a text box. Any help is appreciated!

  I want to say if YearName = "2014" then display the field total for 2014. Or if YearName ="2013" then display field total for 2013

  I have tried using IIF but keep getting errors =IIf((Fields!YearName.Value, "DataSet1") ="2014", (Fields!Total.Value, "DataSet1"), "No Value")

  I get this

  ystem.Web.Services.Protocols.SoapException: The Value expression for the textrun ‘Textbox1.Paragraphs[0].TextRuns[0]’ contains an error: [BC30455] Argument not specified for parameter 'FalsePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.

  at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)

  at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)

  [CREATE TABLE #Table (

  YearName INT

  ,Total INT

  )

  INSERT INTO #Table VALUES ( '2014', 2400), ( '2013', 2500), ( '2012', 2700), ( '2011', 3000)

  SELECT * FROM #Table

  DROP TABLE #Table

  ***SQL born on date Spring 2013:-)