SSRS: Display a message when User enter wrong parameter...(Parameter validation)

• Dark Knight

  SSC Eights!

  Points: 951

  More actions

  March 12, 2015 at 2:26 pm

  #295945

  Issue #1 I have a report that takes 8 character parameter, A error message needs to popped out if user enters parameter less than 8 character.

  Issue #2 I have a report with Tablix. A message needs to display if Tablix returns no Rows.

  I need help with the expressions and where to apply it.

  Thanks in Advance.

  Ram

• pietlinden

  SSC Guru

  Points: 63198

  More actions

  March 12, 2015 at 5:47 pm

  #1783750

  #1: one way is to use a value list of the possible values. If you create a dataset of the values you can just use it.

  #2. You can use the NoRows property of the tablix to show a message. Right-click on the top left of the tablix, then show Properties.