how to bind stored procedure to cruystal Reports RSS

• • Reply
  

  narasappa

  Participant

  960 Points

  458 Posts

  how to bind stored procedure to cruystal Reports

  Apr 23, 2012 05:53 AM|LINK

  hi all

  can any one suggest me  how to bind stored procedure to crystal report

  Narasappa C J
  ravi.jadiyannavar@gmail.com
  Pls Mark This Post As Answer If it Helps U..
  Thanku
  • Edited by narasappa on Apr 23, 2012 05:53 AM
• • Reply
  

  atulthummar

  Participant

  1610 Points

  388 Posts

  Re: how to bind stored procedure to cruystal Reports

  Apr 23, 2012 06:05 AM|LINK

  Hi,

  Add the stored procedure into your report; like you would add a table.

  Add the parameters the stored procedure needs to run; as parameters with exactly the same name they have on the stored procedure.

  So if the SP had two parameters, @PARAM1 and @PARAM2 you would need these same paramaters (name, type etc) in your report.

  Crystal will allow you to use the SP returned fields like any normal table's fields.

  refer  Below artical as a ref.

  http://forums.asp.net/t/1146626.aspx/1

  http://www.pdssoftware.com/newsletter/mar07/page6.htm

  http://www.dbforums.com/microsoft-sql-server/1621221-calling-stored-procedure-crystal-report.html

  Thanks & Best Regards,
  Atul T.
  
  Please click "mark as answer" if this post helped you.
  • Marked as answer by Young Yang - MSFT on Apr 30, 2012 03:10 PM