Report Date Error

Hi,
Back in 2004, 'Lisa' posted this question. I'm having exactly the same
issue. No resolution was proposed at that time. If anyone can help me out,
I'd appreciate it greatly!
-- begin quoted message --
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.
I'm out of ideas, so any help would be greatly appreciated!
--
Thanks!
ChrisCheck to see what her regional & language options are.
You will find these defined in the control panel.
Be sure they match what they are supposed to be - in other words - check the
machine where it is running fine vs. the values on this machine for the
regional & langage options.
If this is english and you are in the U.S. then click the button "Customize"
(On the regional options tab in the dialog for Regional and Language Options
box) and verify that those settings also match on the machines that are
running fine.
=-Chris
"ChrisE" <ChrisE@.discussions.microsoft.com> wrote in message
news:0FACE68F-B113-40D9-9C43-6D950FAB4334@.microsoft.com...
> Hi,
> Back in 2004, 'Lisa' posted this question. I'm having exactly the same
> issue. No resolution was proposed at that time. If anyone can help me
> out,
> I'd appreciate it greatly!
> -- begin quoted message --
> 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.
> I'm out of ideas, so any help would be greatly appreciated!
> --
>
> Thanks!
> Chris|||Hi,
Thanks - this solved the problem. Her computer was configured to English -
Canadian instead of English - US. Changing it to English - US fixed the
problem.
Thanks again!
"Christopher Conner" wrote:
> Check to see what her regional & language options are.
> You will find these defined in the control panel.
> Be sure they match what they are supposed to be - in other words - check the
> machine where it is running fine vs. the values on this machine for the
> regional & langage options.
> If this is english and you are in the U.S. then click the button "Customize"
> (On the regional options tab in the dialog for Regional and Language Options
> box) and verify that those settings also match on the machines that are
> running fine.
> =-Chris
>
> "ChrisE" <ChrisE@.discussions.microsoft.com> wrote in message
> news:0FACE68F-B113-40D9-9C43-6D950FAB4334@.microsoft.com...
> > Hi,
> >
> > Back in 2004, 'Lisa' posted this question. I'm having exactly the same
> > issue. No resolution was proposed at that time. If anyone can help me
> > out,
> > I'd appreciate it greatly!
> >
> > -- begin quoted message --
> >
> > 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.
> >
> > I'm out of ideas, so any help would be greatly appreciated!
> >
> > --
> >
> >
> > Thanks!
> >
> > Chris
>
>sql