all groups > sql server reporting services > september 2004 >
You're in the

sql server reporting services

group:

Subscription failed


Subscription failed Lisa
9/17/2004 1:33:02 PM
sql server reporting services:
Hi,
I have a report set up that is used by multiple users who have subscriptions
set up on it. One user gets the following error when she tries to run it and
the subscription she set up fails:

Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot read the next data row for the data set CustomerDB. --->
System.Data.SqlClient.SqlException: The conversion of char data type to
smalldatetime data type resulted in an out-of-range smalldatetime value.

She is the only user that gets this error and she is set up the same as the
other ones on the reporting server. There is nothing in the report that is
user specific and no formulas that involve a date so I'm really not sure
where this message is coming from. When she logs onto the report from a
different computer it works fine, but if anyone tries logging in and running
the report from her computer it doesn't work. I checked her browser settings
and they are the same as everyone elses.

Re: Subscription failed Tibor Karaszi
9/19/2004 7:08:50 PM
Sound like a regional settings issue to me... Are you passing date in as parameters and/or do you
have date coming out from the reports (in the datasets)?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


[quoted text, click to view]

AddThis Social Bookmark Button