Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to pass parameters to stored procedure

Status
Not open for further replies.
jchennuri

jchennuri

Programmer
Jun 23, 2005
25
US
Hi

I have stored procedure(db is sql server 2000) which needs a parameter to input.
I want to call that stored procedure in a report version XI

How to call it.

Thanks in advance.

Jagadish.
 
Sort by date Sort by votes
Just add the Stored Procedure to your report and the parameter will be automatically added to the parameter list of the report.


-Mo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
893
Kennymc
Kennymc
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
693
hilfy
hilfy
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
584
Ivan Kok
Ivan Kok
BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
653
hilfy
hilfy
Dimitrie1
  • Locked
  • Question
string parameters in command
Replies
3
Views
623
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top