• Not sure if that helps but I had a similar problem and I seem to have fixed it by changing my stored procedure parameter type from DATE to SMALLDATETIME.

    I assume that this is because DATE type did not exist at the time of SSRS 2005 so it must have used SQL Variant...

    The bizarre thing is that it seemed to work for a quite while before it started to show that error...