SSRS Prompts for a WHERE statement

• Gary Mitchell

  SSC Rookie

  Points: 26

  More actions

  August 30, 2007 at 8:21 pm

  #373718

  I am being prompted for a WHERE statement at report run time in the SSRS SQL statement. Is this a database trigger implementation, something in a Stored Procedure or is this facility part of SSRS?

• Korrapati

  SSC Veteran

  Points: 254

  More actions

  September 4, 2007 at 4:51 am

  #731149

  If you have a where statement in your stored procedure (data set for report), you will be prompted for the value.

  Srinivas