[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Report parameter validation failed

Posted on 2011-05-06
4
Medium Priority
?
2,299 Views
Last Modified: 2012-05-11
I have a simple report that contain one query with one internal parameter, I have accessed this report through the URL at one point.  At some point I made a change and no longer can access the report via the URL. I can see it on the preview in BI but anywhere else I get the following error:  

Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError)


I would appreciate any help, I have removed the default value, the available values, tried different variations.  
0
Comment
Question by:FPLES
  • 2
  • 2
4 Comments
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 35705568
Can you upload the report. Make a copy and rename the copy to .txt or .xml. EE doesn't allow .rdl.
0
 
LVL 2

Author Comment

by:FPLES
ID: 35705688
Here is the report, thanks for your help
Agnt-Report.txt
0
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 2000 total points
ID: 35705887
You say you can preview it in BI (which is 'SQL Server Business Intelligence Development Studio' I suppose). When I try to preview the report I get a 'The TyGr parameter is missing a value'.
What edition of SSRS are you using 2005, 2008 or 2008 R2?
I got the same error when running the report from a url. But I could run the report with this url:
http://localhost/ReportServer_SQLEXPRESS2008R2/Pages/ReportViewer.aspx?%2fSSRS%2fAgnt-Report&rs:Command=Render&TyGr=a
See
http://www.mssqltips.com/tip.asp?tip=1336
0
 
LVL 2

Author Closing Comment

by:FPLES
ID: 35705993
Thnaks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month18 days, 8 hours left to enroll

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question