No Data scenario

• nkp01

  Newbie

  Points: 6

  More actions

  March 22, 2005 at 4:13 pm

  #163960

  MS Access has an Event Handler when there is no data to display.  Is there such a thing in Reporting Services? 

   

  My StoredProcedure is returning nothing,…i.e., rowcount is zero.  For this scenario I need to display a “invalid number” type message.  In code I can check for Null.  However, there is no record with a Null in it,…hence I can’t evaluate it.

   

  Any ideas?

   

  Thanks!

   

  RS newbie

• Parker Smith

  SSChasing Mays

  Points: 619

  More actions

  March 23, 2005 at 5:55 am

  #548432

  Data containers like lists have a NoRows property, where you can enter a message to be displayed when there is no data returned.

  This should give you something to test against.