SSRS 2005

• rituraj.bist

  Newbie

  Points: 1

  More actions

  September 16, 2008 at 3:32 am

  #212691

  I want to show a column in the table only if a data comes for that column else i want to hide that column.

  e.g. i have a table having three columns Name, Address and Phone Number.

  Now if for a corresponding name ph no is not there then the column ph no. should not be shown. should hide.

  let the name be my report parameter.:)

  any1 has ne idea .........

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  September 16, 2008 at 4:53 am

  #872243

  Hello,

  You can set the Hidden property to True or False based on the result of an IIf expression.

  Take a look at the following article that describes something similar (setting the Colour, rather than the Hidden property): http://www.c-sharpcorner.com/UploadFile/PennCreative/SSRS_Expressions_Intro01062008171617PM/SSRS_Expressions_Intro.aspx

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group

• abhijeetv

  SSCommitted

  Points: 1945

  More actions

  September 16, 2008 at 5:46 am

  #872272

  In the properties of your textbox, go to the Visibility > Hidden property and add the expression:

  =iif(Fields!YourField.Value=0,True,False)

  You can change the expression as your requirement, currently it is checking for zero value....