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

Question

I have a basic report that brings back some store information.
Select StoreName, StoreNum, StoreDESC from dbo.Store where StoreName = @StoreName
OR ISNULL(@StoreName, '') = ''

But when i call the report from a its web link with the parameter i get
Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError)

http://ssrs-test.mylocation.com/Reports/Pages/Report.aspx?ItemPath=%2fTEST%2fStoreInfo&rs:Command=Render&StoreName=This%20Store

because i have the isnull all store info comes back not just the data for 'This Store"

Answer 1

What you posted is the SQL query, not the report parameters. They are different things. Go to your report designer's Parameters UI. Each of the parameters listed there must either have a default value or be assigned a value when calling the report. Note that case matters in parameter names so ensure the parameter name matches the URL value.

Also it seems like you're trying to use URL access and in that case I don't believe the URL is correct. Normally it is something like http://ssrs-test.mylocation.com/ReportServer?/%2fTEST%2fStoreInfo&rs:Command=Render&StoreName=This%20Store. The URL you appear to be using is for the Report Manager UI which is not something you would generally programmatically use.

Answer 2

Hi @Hopkins, Lee (Houston)

You can check the official document about the URL Access in SSRS :https://learn.microsoft.com/en-us/sql/reporting-services/pass-a-report-parameter-within-a-url?view=sql-server-ver16

I did a local test ,here are my steps ,you can take a reference :
The parameter:

The dataset:

test the access url

preview result:

when there is no value pass to parameter :

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

ok I am an idiot, i was given the link that contained Pages/Report.aspx?ItemPath= not Pages/ReportViewer.aspx? Missed that the parameters need to go through the reportviwer