Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError)
I saw this error the other day and it took me a minute to recall how I’ve fixed this in the past.
If you are unfamiliar with SSRS and Visual Studios, it can be a little “unfriendly” with some features. Specifically in this case, taking a parameter that used to be hidden and making it a visual integral part of the report. In my particular circumstance, this report is not testable in visual studio and has to be uploaded to a server in order to validate.
I found a few articles and posts, but none of them helped me in this circumstance:
The things I tried I really thought that would work:
- Changing one of my dependent parameters populated from a data set to refresh when it sees fit and not automatically every time.
- Copying an existing and working parameter that is similar over the old one in the XML and tweaking it slightly.
- Saving and exiting the report.
- Deleting the parameter and re-creating the parameter.
- Scouring the XML for all references to the parameter and making sure it all was kosher.
What did work in the end:
Deleting the report off the report server and re-uploading it. Overwriting the report / uploading and applying the updates to it did not change anything and it gave me a consistent error. After I deleted it from the server and re-uploaded it, the error was gone completely.
I have added in a form for feedback, it would be very helpful if you would take a few minutes to fill this out. My goal is to adjust the content to best help others resolve their problems.