Hide Table Display Txt Box

• LOOKUP_BI-756009

  SSCertifiable

  Points: 7286

  More actions

  May 23, 2008 at 10:58 am

  #188157

  Hi all,

  My report has a number of tables.

  These table design is as [Total(numeric),Year(numeric),Month(varchar(15)].

  Each table on report is populated based on individual tables in Mngt Studio.

  My problem is.If table is empty,the table on report does not get populated/displayed.It is hidden.How do I return a message,Example {"No Value for table A"} instead and show the table in report only when the table has some value.

  I have written an expression like this.But it just hides the table if its empty,and im not able to return a value "No Value"instead.

  =IIF(Fields!Month.Value IS Nothing,"No Value for table A",False)

• checkai

  Hall of Fame

  Points: 3041

  More actions

  May 29, 2008 at 9:41 am

  #821826

  There is a NoRows property on a table that you can enter in any message that you'd like to display when the dataset returns 0 rows.