Passing Multiple values in Stored Procedure in SSRS

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

When I am passing multiple values parameter in SSRS as Query it's working but when I'm passing multiple value parameters as Stored Procedure it's not working.

Could anyone please give a solution for this?

Thanks,
Prasant

Posted 23-Nov-10 6:28am

User CP

Updated 23-Nov-10 6:36am

Slacker007

v2

Add a Solution

Comments

Henry Minute 23-Nov-10 13:46pm

An hour has passed without your getting an answer so I suspect that others, like myself, do not understand what you want. It might help if you edited your question (click on the 'Improve Question' widget) to show examples of the code that is failing.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Lantei · Answer 1 · 2010-11-24T00:55:00

It might be due to type mismatch, make sure the parameter values you are passing in are of the same type to that of the stored procedure parameters.

Also if you worked on an existing stored procedure (which will have a dataset in SSRS), Then make sure you REFRESH the dataset before you test your report.

Also build your stored procedure well..I think thats the most important thing, you probably might be doing something that is not making your stored procedure run well..After building your stored proc. do not just use it straight in SSRS, first run a manual exec with dummy data values in SQL Server to ascertain its in perfect shape before you begin using it in SSRS.

I belive if you stick to these guidelines and more, you wont be having problemsw with SSRS/Stored Procs (I use them all the time) and it works perfectly :)