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.
Probably incorrect Date format on the server. To resolve it, change the Date format on the host to en-us via Control Panel