row visibility

• harri.reddy

  SSCommitted

  Points: 1957

  More actions

  June 25, 2012 at 1:20 pm

  #392599

  my expression gives me error ,in row visibility

  =iif(Fields!Target.Value*100 = 0.0 and

  Fields!Market.Value/SUM(Fields!Market.Value,"Group")*100 =0.0,true,false),

  error "

  Error58[rsCompilerErrorInExpression] The Visibility.Hidden expression for the tablix ‘Tablix1’ contains an error: [BC30455] Argument not specified for parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'"

  plz help

• Spiff

  SSCertifiable

  Points: 7826

  More actions

  June 27, 2012 at 8:37 am

  #1506179

  Somehow you have a special character in between the "and" clause and where you line break. Just delete it so the expression is on one line i.e

  =iif(Fields!Target.Value*100 = 0.0 and Fields!Market.Value/SUM(Fields!Market.Value,"Group")*100 =0.0,true,false)

  Syntactically the expression is fine.