An SSRS procedure or function "" expects a parameter '' that was not provided

Question

I have an SSRS report to which I pass the Date start and end date parameter, but I continue to receive the following error:

The procedure or function 'MyReport' expects the parameter '@startDate', which was not provided.

I created a parameter in my report and matched it in my DataSet. I don’t understand what I am missing here. Any ideas? Any help is greatly appreciated.

SQL

ALTER PROCEDURE [dbo].[MyReport] @startDate datetime, @endDate datetime AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; SELECT * FROM myReportTbl tbl WHERE tbl.[Updated] >= @startDate AND tbl.[Updated] <= @endDate END 

Report Code

 <DataSet Name="DataSet1"> <Query> <DataSourceName>Dev</DataSourceName> <QueryParameters> <QueryParameter Name="@startDate"> <Value>=Parameters!StartDate.Value</Value> <rd:UserDefined>true</rd:UserDefined> </QueryParameter> <QueryParameter Name="@endDate"> <Value>=Parameters!EndDate.Value</Value> <rd:UserDefined>true</rd:UserDefined> </QueryParameter> </QueryParameters> <CommandText>MyReport</CommandText> </Query> 

Answer 1

I found a problem. It was pretty stupid, but I swear I did it in the past. I set the Query Type in the dataset to Text , and it should be the Stored Procedure .

Answer 2

Check if the parameters are correct. I got errors in the past due to problems with the case.

Report parameters are case sensitive.

https://msdn.microsoft.com/en-us/library/ms155391.aspx

Answer 3

Try deleting the parameters, and then go to the properties of the dataset and click on the update fields that should recreate them for you.