ssrs 2008

• wendy elizabeth

  SSCoach

  Points: 16915

  More actions

  March 9, 2010 at 6:57 am

  #216320

  When no data is selected on a SSRS 2008 report, I want to display between two to 5 sentences when no data is selected. When I use the no rows message property, I only get a sentence length for the message. What can I do if I want the message to be longer? Is there an if statement that I can use?

• Rajesh Jonnalagadda

  Ten Centuries

  Points: 1032

  More actions

  March 20, 2010 at 5:48 am

  #1137168

  Hi,

  In NoRowsMessage Property you can use IIF Statements

  Just Like

  =IIF(Parameters!A.Value = "Test", "Test Data Not Available", "Sample Data Not Available")