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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure Parameter

Status
Not open for further replies.
lesleycampbell

lesleycampbell

Technical User
Jun 21, 2013
59
US
I am working in CR11. I am building a report from a store procedure and adding some additional information to it. Everything works fine except for one parameter.

There is a 'user id' parameter built into the store procedure that I wish to ignore. Is there anyway to do that?
 
Sort by date Sort by votes
If you can change the stored procedure you can change the type of the parameter as OUTPUT and set a default value. This will make it optional ( for the stored procedure)

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
396
hilfy
hilfy
hpl2001
  • Locked
  • Question
Report stored in history getting updated
Replies
5
Views
153
lbass
lbass
Dimitrie1
  • Locked
  • Question
string parameters in command
Replies
3
Views
395
kray4660
kray4660
allyne
  • Locked
  • Question
Crystal 2008 Stored Procedure with parameter
Replies
1
Views
112
hilfy
hilfy
Halliarse
  • Locked
  • Question
Pass and retrieve data to and from a Stored Procedure
Replies
11
Views
201
Halliarse
Halliarse

Part and Inventory Search

Sponsor

Back
Top