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

Question

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.

Answer 1

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