Report Server error

I have a RS200 server with many reports that work fine. There is one report
that comes up with the following error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'StockCoverage'.
(rsErrorExecutingCommand) Get Online Help
Error converting data type nvarchar to smalldatetime.
The dataset invokes a stored procedure. The report renders perfectly in the
development environment, VS.Net. The stored proc produces the desired results
with Query Analyser and various other tools. Once deployed to the Report
Server the error comes up. Can you help ?Hi Claude,
RS have very close for datetime format.
You have 2 solutions:
-User a corect format mm/dd/yyyy 0:00:00, ex 10/21/2005 14:55:25
-Or converter the string to smalldatetime with convert() funtion in the
expresion where you use the value.
I hope help you
"Claude" wrote:
> I have a RS200 server with many reports that work fine. There is one report
> that comes up with the following error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'StockCoverage'.
> (rsErrorExecutingCommand) Get Online Help
> Error converting data type nvarchar to smalldatetime.
> The dataset invokes a stored procedure. The report renders perfectly in the
> development environment, VS.Net. The stored proc produces the desired results
> with Query Analyser and various other tools. Once deployed to the Report
> Server the error comes up. Can you help ?|||Hey Manuel,
Thanks for the response. The report runs perfectly in the preview tab while
designing it in VS.Net. So I think all the datetime handling is correct.
(The Report server is local by the way)
Any other ideas ?
Cheers,
Claude
"Manuel" wrote:
> Hi Claude,
> RS have very close for datetime format.
> You have 2 solutions:
> -User a corect format mm/dd/yyyy 0:00:00, ex 10/21/2005 14:55:25
> -Or converter the string to smalldatetime with convert() funtion in the
> expresion where you use the value.
> I hope help you
>
> "Claude" wrote:
> > I have a RS200 server with many reports that work fine. There is one report
> > that comes up with the following error:
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Query execution failed for data set 'StockCoverage'.
> > (rsErrorExecutingCommand) Get Online Help
> > Error converting data type nvarchar to smalldatetime.
> >
> > The dataset invokes a stored procedure. The report renders perfectly in the
> > development environment, VS.Net. The stored proc produces the desired results
> > with Query Analyser and various other tools. Once deployed to the Report
> > Server the error comes up. Can you help ?|||Oh silly boy ! The data type of the report parameter needs to be DateTime !
In the dev environment it is obviously interpreted correctly . . .
"Claude" wrote:
> I have a RS200 server with many reports that work fine. There is one report
> that comes up with the following error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'StockCoverage'.
> (rsErrorExecutingCommand) Get Online Help
> Error converting data type nvarchar to smalldatetime.
> The dataset invokes a stored procedure. The report renders perfectly in the
> development environment, VS.Net. The stored proc produces the desired results
> with Query Analyser and various other tools. Once deployed to the Report
> Server the error comes up. Can you help ?