I'm creating a SSRS 2005 report in VS 2005, and having a bit of trouble calling a stored procedure rather than using inline SQL. I have just put the name of the stored proc 'StoredProc1' in the Data window, and added my parameters to the Report Parameters menu, but I'm not sure if this is the right way to do things as when I click on Preview I get the error that the parameter has not been provided. Can anybody help?
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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
creating report based on stored proc with params
- Thread starter mjd3000
- Start date
Enter the stored proc name with the parameters that you have set up e.g.
exec StoredProcName @ParamOneName, @Param2Name
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
exec StoredProcName @ParamOneName, @Param2Name
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question