Stored Procedure Parameter

[lesleycampbell]

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?

 

[PeterDimitrov]

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)

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.