Pass parameters to SSRS

I have SSRS 2008 report, application pass parameters in URL (some State name) to SSRS report, the URL as below.  The report itself runs well,  but report cannot be displayed on server, error:

"Default value or value provided for the report parameter 'State' is not a valid value"

I found if I removed some States from URL, it would display report.  I.e., some states work, some states don't work.

http://servername/ReportServer?/ApplicationName/DepartmentStore&State=AL&State=AK&State=AR&State=CA&State=CO&State=CT&State=DE&State=DC&State=FL&State=GA&State=HI&State=FL&rc:Parameters=FALSE
5281Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CodeCruiserCommented:
Have you established which states are causing the problem? If you have, try just passing one of the problem states and see if it works.
0
5281Author Commented:
It doesn't work if I just pass one of the problem states.
0
CodeCruiserCommented:
An example problem state?
0
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

5281Author Commented:
To me the problem states don't have anything in common.  I really have no idea what would be the problem.  I used the trim() function to trim the State string.  

I saw an Microsoft article, could it be something like that? https://support.microsoft.com/kb/970058#appliesto

But I don't know how to work around with this problem.  Please advise.
0
5281Author Commented:
I am thinking to pass parameters (those states) through the code, instead of URL.  Do yo have a sample code in VB.net.  Thanks.
0
5281Author Commented:
The SSRS report is in PDF format, the examples are passing parameters from ReportViewer Control to SSRS.  I don't think I have a ReportViewer control in the asp.net application.
0
5281Author Commented:
How to pass parameters from asp.net project to SSRS pdf format?  I think it is my question.
0
CodeCruiserCommented:
I think for server report, you may have to rely on URL to pass parameters. You can pass parameters to local report with the other method I linked above.
0
5281Author Commented:
If the only way to pass parameters for server report is through URL , I don't understand why I have the error message for some State, but not others.

"Default value or value provided for the report parameter 'State' is not a valid value"
0
CodeCruiserCommented:
Is the parameter configured to be multivalue?
0
5281Author Commented:
There are two datasets, the report only use the first dataset, the parameter is set to "Allow multiple values", the parameter is set "Get values from a query" from the 2nd dataset.  Is that right?
0
CodeCruiserCommented:
Parameter seems to be right but not sure about the 2nd dataset.
0
5281Author Commented:
The 2nd dataset is used for testing purpose, so the parameter dropdownbox on report can list items.
0
CodeCruiserCommented:
And that dataset contains all the states that you are passing?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
5281Author Commented:
2nd dataset contains all the states I am passing.
0
5281Author Commented:
Should I remove 2nd dataset and test?
0
CodeCruiserCommented:
Yeah worth a try.
0
5281Author Commented:
The problem is that there are some space after the name of State in database, so it doesn't match the URL.  I trimmed it in query.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.