sql server reporting services: Report Server error -- sql server reporting services

Report Server error

Claude
10/20/2005 10:30:02 PM

sql server reporting services:

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

RE: Report Server error

Manuel
10/21/2005 6:00:03 AM

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

[quoted text, click to view]

RE: Report Server error

Claude
10/24/2005 4:01:03 PM

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

[quoted text, click to view]

RE: Report Server error

Claude
11/7/2005 10:02:02 PM

Oh silly boy ! The data type of the report parameter needs to be DateTime !
In the dev environment it is obviously interpreted correctly . . .

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.