Report filed with IIF

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  September 3, 2009 at 6:57 pm

  #210408

  Hi,

  How can is set the filed on the report to show only records with certain set

  for example:

  i only want to show field.recordid = not null other needs to be excluded.

  How can i do it?

  Thanks

  pat

• drew.allen

  SSC Guru

  Points: 76985

  More actions

  September 4, 2009 at 7:09 am

  #1049342

  You have two options depending on what you need. Typically, I would just exclude these records from the original dataset in the first place. The other option is to set the Visibility properties for the field/row to whatever expression you need.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA

• Rajesh Jonnalagadda

  Ten Centuries

  Points: 1032

  More actions

  September 4, 2009 at 7:40 am

  #1049361

  Hi,

  Select table and Click F4

  In Report Properties Window goto Filter

  Enter Filter Condition in it