Hide Records if Field is null??

• cpicard

  Mr or Mrs. 500

  Points: 563

  More actions

  November 10, 2009 at 2:43 pm

  #227819

  Hello,

  I have a report that returns 540 records. About half have a field that is empty/null and I would like to hide those.

  The field name is DefendantName (varchar)

  I would like to apply a filter to the effect of..

  If DefendantName is null then hide record.

  Any suggestions?

  Thanks again! This forum has been a life saver. 😛

• UnionAll

  SSCrazy

  Points: 2102

  More actions

  November 10, 2009 at 5:47 pm

  #1077605

  =iif(Feilds!FeildName.value is nothing,true,false)

  try this expression in the hidden property.

  let me know if this works.

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  November 11, 2009 at 6:26 am

  #1077745

  Hi ,

  One other option is , select the Dataset--> Click the edit option-->Choose Filter tab --> Select required field in Expression column--> select != in operator --> Give value as NULL .

  Regards,

  MC

  Thanks & Regards,
  MC

• rene-500237

  Hall of Fame

  Points: 3769

  More actions

  November 12, 2009 at 3:31 am

  #1078230

  Hi,

  In Dataset filter out your empty records with

  where DefendantName is not Null

  Regards