How to use stored procedure with parameters

• piyush.patel

  Newbie

  Points: 7

  More actions

  February 25, 2009 at 9:17 pm

  #200286

  Hi everyone,

  I am using a stored procedure as my query string in SSRS 2008 report.

  How can I pass parameter to stored procedure.

  If I add parameters as query parameters, It raises error at execution that "ERROR [42000] expects parameter 'XYZ', which is not supplied."

  if i write my query string like

  "storedprocnamme para1,para2"

  then it works fine.

  But its not right to give parameters manually,

  Please help me in this Problem.

  Thanks.

  From Piyush.

  F

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  February 25, 2009 at 9:57 pm

  #950411

  Hello,

  May be take a look at this article:-

  http://en.csharp-online.net/Building_Reports_in_SQL_Server_2005%E2%80%94Setting_Report_Parameters_with_Stored_Procedures

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group