The value provided for the report parameter '' is not valid for its type. (rsReportParameterTypeMismatch)

pedram picture pedram · Feb 6, 2016 · Viewed 8.5k times · Source

I am working on SSRS Report.

Continuously getting bellow error does anyone have idea to sovle?

The value provided for the report parameter '' is not valid for its type. (rsReportParameterTypeMismatch)

Using query something like below - My query type is Text

CREATE TABLE #Temp
(
    ....
) 

INSERT INTO #Temp
  (
   ...
  )
SELECT ...
FROM   ... joins TABLE....
WHERE  d.Date BETWEEN @FromDate AND @ToDate

SELECT ...
FROM   #Temp 
.. joins TABLE...
WHERE ...

DROP TABLE #Temp

Image that shows the error.

enter image description here

Answer

Yair Maron picture Yair Maron · May 19, 2020

Probably incorrect Date format on the server. To resolve it, change the Date format on the host to en-us via Control Panel