More on Runaway Log Files

I had to stop the RS service on our server. It's creating 30 megabyte log
files, once every minute. I can still serve up reports evidently with the
ReportServer service stopped in Control Panel, but I doubt I can publish
reports.
If I start the service, the log files immediately start to pile up.
Any ideas? Any way to just stop logging?
JeffYou should contact PSS for a fix for this issue. Restarting the service
should make the problem go away but it could come back at anytime.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
news:e$H8GRsjEHA.156@.TK2MSFTNGP10.phx.gbl...
> I had to stop the RS service on our server. It's creating 30 megabyte log
> files, once every minute. I can still serve up reports evidently with the
> ReportServer service stopped in Control Panel, but I doubt I can publish
> reports.
> If I start the service, the log files immediately start to pile up.
> Any ideas? Any way to just stop logging?
> Jeff
>|||Hi!
Nice to hear, as we have the same problem.
Would you be so kind to tell me what PSS is and how to contact them?
Armin Mueller
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:erEFxDtjEHA.596@.TK2MSFTNGP11.phx.gbl...
> You should contact PSS for a fix for this issue. Restarting the service
> should make the problem go away but it could come back at anytime.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
> news:e$H8GRsjEHA.156@.TK2MSFTNGP10.phx.gbl...
> > I had to stop the RS service on our server. It's creating 30 megabyte
log
> > files, once every minute. I can still serve up reports evidently with
the
> > ReportServer service stopped in Control Panel, but I doubt I can publish
> > reports.
> >
> > If I start the service, the log files immediately start to pile up.
> >
> > Any ideas? Any way to just stop logging?
> >
> > Jeff
> >
> >
>|||Microsoft Product Support Services. See
http://support.microsoft.com/default.aspx?pr=cntactms&style=home. We are
working on the fix and should have a KB article number by the end of this
week.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Armin Mueller" <armin.mueller@.cosmicos.de> wrote in message
news:%23zEQTD$kEHA.3432@.TK2MSFTNGP14.phx.gbl...
> Hi!
> Nice to hear, as we have the same problem.
> Would you be so kind to tell me what PSS is and how to contact them?
> Armin Mueller
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:erEFxDtjEHA.596@.TK2MSFTNGP11.phx.gbl...
>> You should contact PSS for a fix for this issue. Restarting the service
>> should make the problem go away but it could come back at anytime.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
>> news:e$H8GRsjEHA.156@.TK2MSFTNGP10.phx.gbl...
>> > I had to stop the RS service on our server. It's creating 30 megabyte
> log
>> > files, once every minute. I can still serve up reports evidently with
> the
>> > ReportServer service stopped in Control Panel, but I doubt I can
>> > publish
>> > reports.
>> >
>> > If I start the service, the log files immediately start to pile up.
>> >
>> > Any ideas? Any way to just stop logging?
>> >
>> > Jeff
>> >
>> >
>>
>|||Can you tell me if there's been any progress on the hotfix and/or the KB
article related to this issue?
Thanks,
Shawn
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ONXc$UFlEHA.536@.TK2MSFTNGP11.phx.gbl...
> Microsoft Product Support Services. See
> http://support.microsoft.com/default.aspx?pr=cntactms&style=home. We are
> working on the fix and should have a KB article number by the end of this
> week.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Armin Mueller" <armin.mueller@.cosmicos.de> wrote in message
> news:%23zEQTD$kEHA.3432@.TK2MSFTNGP14.phx.gbl...
> > Hi!
> >
> > Nice to hear, as we have the same problem.
> >
> > Would you be so kind to tell me what PSS is and how to contact them?
> >
> > Armin Mueller
> >
> > "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> > news:erEFxDtjEHA.596@.TK2MSFTNGP11.phx.gbl...
> >> You should contact PSS for a fix for this issue. Restarting the
service
> >> should make the problem go away but it could come back at anytime.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
> >> news:e$H8GRsjEHA.156@.TK2MSFTNGP10.phx.gbl...
> >> > I had to stop the RS service on our server. It's creating 30 megabyte
> > log
> >> > files, once every minute. I can still serve up reports evidently with
> > the
> >> > ReportServer service stopped in Control Panel, but I doubt I can
> >> > publish
> >> > reports.
> >> >
> >> > If I start the service, the log files immediately start to pile up.
> >> >
> >> > Any ideas? Any way to just stop logging?
> >> >
> >> > Jeff
> >> >
> >> >
> >>
> >>
> >
> >
>|||Yes, the hotfix is now available although the KB article is not finished.
Ask product support for the fix associated with KB 885286.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Hansen" <shansen@.lrs.com> wrote in message
news:%23oPKgdomEHA.1712@.TK2MSFTNGP09.phx.gbl...
> Can you tell me if there's been any progress on the hotfix and/or the KB
> article related to this issue?
> Thanks,
> Shawn
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ONXc$UFlEHA.536@.TK2MSFTNGP11.phx.gbl...
>> Microsoft Product Support Services. See
>> http://support.microsoft.com/default.aspx?pr=cntactms&style=home. We are
>> working on the fix and should have a KB article number by the end of this
>> week.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Armin Mueller" <armin.mueller@.cosmicos.de> wrote in message
>> news:%23zEQTD$kEHA.3432@.TK2MSFTNGP14.phx.gbl...
>> > Hi!
>> >
>> > Nice to hear, as we have the same problem.
>> >
>> > Would you be so kind to tell me what PSS is and how to contact them?
>> >
>> > Armin Mueller
>> >
>> > "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> > news:erEFxDtjEHA.596@.TK2MSFTNGP11.phx.gbl...
>> >> You should contact PSS for a fix for this issue. Restarting the
> service
>> >> should make the problem go away but it could come back at anytime.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >>
>> >>
>> >> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
>> >> news:e$H8GRsjEHA.156@.TK2MSFTNGP10.phx.gbl...
>> >> > I had to stop the RS service on our server. It's creating 30
>> >> > megabyte
>> > log
>> >> > files, once every minute. I can still serve up reports evidently
>> >> > with
>> > the
>> >> > ReportServer service stopped in Control Panel, but I doubt I can
>> >> > publish
>> >> > reports.
>> >> >
>> >> > If I start the service, the log files immediately start to pile up.
>> >> >
>> >> > Any ideas? Any way to just stop logging?
>> >> >
>> >> > Jeff
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>

Monthly Reports - Date Format

I have a report that charts our weekly sales and monthly sales. I use the
following SQL statement to reflect 7 days or 30 days, which works but not
properly. I'd like for my report to run from Sunday to Sunday for the 7-day
report, and from the 1st of the month to the end of the month, regardless of
the number of days in the month. How do I modfify my statement to do this?
Here's my SQL statement for the 30-day or monthly report:
SELECT receipt_date, SUM(total_amt) AS Total_AMT, receipt_no, stamp, COUNT
(*) AS TOT
FROM Sysadm.receipt
WHERE (receipt_date BETWEEN CONVERT(datetime, CONVERT(varchar, DATEADD(day,
-30, GETDATE()), 101), 101) AND CONVERT(varchar, DATEADD(day, 0, GETDATE()),
101), 101))
GROUP BY receipt_date, receipt_no, stamp
ORDER BY receipt_date
--
EnchantnetI used the following statement to run a report for the previous week, from
Saturday to Friday:
CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 7 - DATEPART(dw, GETDATE()),
101), 101) AS StartDt,
CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 1 - DATEPART(dw, GETDATE()),
101), 101) AS EndDt
You could probably use a variation of this for your monthly report. I hope
this helps!
"Enchantnet" wrote:
> I have a report that charts our weekly sales and monthly sales. I use the
> following SQL statement to reflect 7 days or 30 days, which works but not
> properly. I'd like for my report to run from Sunday to Sunday for the 7-day
> report, and from the 1st of the month to the end of the month, regardless of
> the number of days in the month. How do I modfify my statement to do this?
> Here's my SQL statement for the 30-day or monthly report:
> SELECT receipt_date, SUM(total_amt) AS Total_AMT, receipt_no, stamp, COUNT
> (*) AS TOT
> FROM Sysadm.receipt
> WHERE (receipt_date BETWEEN CONVERT(datetime, CONVERT(varchar, DATEADD(day,
> -30, GETDATE()), 101), 101) AND CONVERT(varchar, DATEADD(day, 0, GETDATE()),
> 101), 101))
> GROUP BY receipt_date, receipt_no, stamp
> ORDER BY receipt_date
> --
> Enchantnet|||Hey DAW,
Thanks for the code. However, I'm a newbie at this sort of stuff and I get
the following error when I entered your code: "ADO error: Incorrect syntax
near the keyword 'AS'. Statement(s) could not be prepared. Deferred prepare
could not be completed." Any idea? Do I need to include or define the
StartDt and EndDt elsewhere?
--
Enchantnet
"daw" wrote:
> I used the following statement to run a report for the previous week, from
> Saturday to Friday:
> CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 7 - DATEPART(dw, GETDATE()),
> 101), 101) AS StartDt,
> CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 1 - DATEPART(dw, GETDATE()),
> 101), 101) AS EndDt
> You could probably use a variation of this for your monthly report. I hope
> this helps!
> "Enchantnet" wrote:
> > I have a report that charts our weekly sales and monthly sales. I use the
> > following SQL statement to reflect 7 days or 30 days, which works but not
> > properly. I'd like for my report to run from Sunday to Sunday for the 7-day
> > report, and from the 1st of the month to the end of the month, regardless of
> > the number of days in the month. How do I modfify my statement to do this?
> > Here's my SQL statement for the 30-day or monthly report:
> >
> > SELECT receipt_date, SUM(total_amt) AS Total_AMT, receipt_no, stamp, COUNT
> > (*) AS TOT
> > FROM Sysadm.receipt
> > WHERE (receipt_date BETWEEN CONVERT(datetime, CONVERT(varchar, DATEADD(day,
> > -30, GETDATE()), 101), 101) AND CONVERT(varchar, DATEADD(day, 0, GETDATE()),
> > 101), 101))
> > GROUP BY receipt_date, receipt_no, stamp
> > ORDER BY receipt_date
> > --
> > Enchantnet|||I'm not sure what that particular error means, but your statement should look
something like:
select CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 7 - DATEPART(dw,
GETDATE()), 101), 101) AS StartDt, CONVERT(datetime, CONVERT(nvarchar,
GETDATE() - 1 - DATEPART(dw, GETDATE()), 101), 101) AS EndDt
from ....
"Enchantnet" wrote:
> Hey DAW,
> Thanks for the code. However, I'm a newbie at this sort of stuff and I get
> the following error when I entered your code: "ADO error: Incorrect syntax
> near the keyword 'AS'. Statement(s) could not be prepared. Deferred prepare
> could not be completed." Any idea? Do I need to include or define the
> StartDt and EndDt elsewhere?
> --
> Enchantnet
>
> "daw" wrote:
> > I used the following statement to run a report for the previous week, from
> > Saturday to Friday:
> > CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 7 - DATEPART(dw, GETDATE()),
> > 101), 101) AS StartDt,
> > CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 1 - DATEPART(dw, GETDATE()),
> > 101), 101) AS EndDt
> >
> > You could probably use a variation of this for your monthly report. I hope
> > this helps!
> >
> > "Enchantnet" wrote:
> >
> > > I have a report that charts our weekly sales and monthly sales. I use the
> > > following SQL statement to reflect 7 days or 30 days, which works but not
> > > properly. I'd like for my report to run from Sunday to Sunday for the 7-day
> > > report, and from the 1st of the month to the end of the month, regardless of
> > > the number of days in the month. How do I modfify my statement to do this?
> > > Here's my SQL statement for the 30-day or monthly report:
> > >
> > > SELECT receipt_date, SUM(total_amt) AS Total_AMT, receipt_no, stamp, COUNT
> > > (*) AS TOT
> > > FROM Sysadm.receipt
> > > WHERE (receipt_date BETWEEN CONVERT(datetime, CONVERT(varchar, DATEADD(day,
> > > -30, GETDATE()), 101), 101) AND CONVERT(varchar, DATEADD(day, 0, GETDATE()),
> > > 101), 101))
> > > GROUP BY receipt_date, receipt_no, stamp
> > > ORDER BY receipt_date
> > > --
> > > Enchantnet|||Sorry, I had that wrong as far as what you need. Try this:
select ....
from...
where date between CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 7 -
DATEPART(dw, GETDATE()), 101), 101) AND CONVERT(datetime, CONVERT(nvarchar,
GETDATE() - 1 - DATEPART(dw, GETDATE()), 101), 101)
"daw" wrote:
> I'm not sure what that particular error means, but your statement should look
> something like:
> select CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 7 - DATEPART(dw,
> GETDATE()), 101), 101) AS StartDt, CONVERT(datetime, CONVERT(nvarchar,
> GETDATE() - 1 - DATEPART(dw, GETDATE()), 101), 101) AS EndDt
> from ....
> "Enchantnet" wrote:
> > Hey DAW,
> >
> > Thanks for the code. However, I'm a newbie at this sort of stuff and I get
> > the following error when I entered your code: "ADO error: Incorrect syntax
> > near the keyword 'AS'. Statement(s) could not be prepared. Deferred prepare
> > could not be completed." Any idea? Do I need to include or define the
> > StartDt and EndDt elsewhere?
> > --
> > Enchantnet
> >
> >
> > "daw" wrote:
> >
> > > I used the following statement to run a report for the previous week, from
> > > Saturday to Friday:
> > > CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 7 - DATEPART(dw, GETDATE()),
> > > 101), 101) AS StartDt,
> > > CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 1 - DATEPART(dw, GETDATE()),
> > > 101), 101) AS EndDt
> > >
> > > You could probably use a variation of this for your monthly report. I hope
> > > this helps!
> > >
> > > "Enchantnet" wrote:
> > >
> > > > I have a report that charts our weekly sales and monthly sales. I use the
> > > > following SQL statement to reflect 7 days or 30 days, which works but not
> > > > properly. I'd like for my report to run from Sunday to Sunday for the 7-day
> > > > report, and from the 1st of the month to the end of the month, regardless of
> > > > the number of days in the month. How do I modfify my statement to do this?
> > > > Here's my SQL statement for the 30-day or monthly report:
> > > >
> > > > SELECT receipt_date, SUM(total_amt) AS Total_AMT, receipt_no, stamp, COUNT
> > > > (*) AS TOT
> > > > FROM Sysadm.receipt
> > > > WHERE (receipt_date BETWEEN CONVERT(datetime, CONVERT(varchar, DATEADD(day,
> > > > -30, GETDATE()), 101), 101) AND CONVERT(varchar, DATEADD(day, 0, GETDATE()),
> > > > 101), 101))
> > > > GROUP BY receipt_date, receipt_no, stamp
> > > > ORDER BY receipt_date
> > > > --
> > > > Enchantnet|||Perfect! Thank u, Thank u, Thank u!!!!!
--
Enchantnet
"daw" wrote:
> Sorry, I had that wrong as far as what you need. Try this:
> select ....
> from...
> where date between CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 7 -
> DATEPART(dw, GETDATE()), 101), 101) AND CONVERT(datetime, CONVERT(nvarchar,
> GETDATE() - 1 - DATEPART(dw, GETDATE()), 101), 101)
> "daw" wrote:
> > I'm not sure what that particular error means, but your statement should look
> > something like:
> >
> > select CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 7 - DATEPART(dw,
> > GETDATE()), 101), 101) AS StartDt, CONVERT(datetime, CONVERT(nvarchar,
> > GETDATE() - 1 - DATEPART(dw, GETDATE()), 101), 101) AS EndDt
> > from ....
> >
> > "Enchantnet" wrote:
> >
> > > Hey DAW,
> > >
> > > Thanks for the code. However, I'm a newbie at this sort of stuff and I get
> > > the following error when I entered your code: "ADO error: Incorrect syntax
> > > near the keyword 'AS'. Statement(s) could not be prepared. Deferred prepare
> > > could not be completed." Any idea? Do I need to include or define the
> > > StartDt and EndDt elsewhere?
> > > --
> > > Enchantnet
> > >
> > >
> > > "daw" wrote:
> > >
> > > > I used the following statement to run a report for the previous week, from
> > > > Saturday to Friday:
> > > > CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 7 - DATEPART(dw, GETDATE()),
> > > > 101), 101) AS StartDt,
> > > > CONVERT(datetime, CONVERT(nvarchar, GETDATE() - 1 - DATEPART(dw, GETDATE()),
> > > > 101), 101) AS EndDt
> > > >
> > > > You could probably use a variation of this for your monthly report. I hope
> > > > this helps!
> > > >
> > > > "Enchantnet" wrote:
> > > >
> > > > > I have a report that charts our weekly sales and monthly sales. I use the
> > > > > following SQL statement to reflect 7 days or 30 days, which works but not
> > > > > properly. I'd like for my report to run from Sunday to Sunday for the 7-day
> > > > > report, and from the 1st of the month to the end of the month, regardless of
> > > > > the number of days in the month. How do I modfify my statement to do this?
> > > > > Here's my SQL statement for the 30-day or monthly report:
> > > > >
> > > > > SELECT receipt_date, SUM(total_amt) AS Total_AMT, receipt_no, stamp, COUNT
> > > > > (*) AS TOT
> > > > > FROM Sysadm.receipt
> > > > > WHERE (receipt_date BETWEEN CONVERT(datetime, CONVERT(varchar, DATEADD(day,
> > > > > -30, GETDATE()), 101), 101) AND CONVERT(varchar, DATEADD(day, 0, GETDATE()),
> > > > > 101), 101))
> > > > > GROUP BY receipt_date, receipt_no, stamp
> > > > > ORDER BY receipt_date
> > > > > --
> > > > > Enchantnet

Monthly Reports

Hi,
Actually I am generating report by stored procedure by passing two parameters like START date and END date.
Now my problem is I need to generate report for every month seperately that fall in range of START date and END date.
thanks
IndiraIndira,
Group by Date, and when creating the group, if you use a date, Crystal will, by default, give the grouping options:
the date, in a dropdown
the order to sort by, in a dropdown,
the grouping frequency, in a dropdown (defaults to "for each day.")
change the last one to "for each month."
Crystal will then produce your summaries for each calendar month within the range.
You can then add a page break after this date group, to start anew page with a new month.
That's how you'd produce one report covering many months, aggregated by each month.
YOur question says you want to produce separate monthly reports.
If they are paper copies, you just restart your page numbering for each new group, print the report out, and then distribute the separate months pages as separate reports.
If you want to produce separate files, you will need to outline which method you want to use to distribute the separate reports, because thismight require code via VB or C etc...

Dave

Month Days

How can you find the days in a particular month in crystal reports v10.
(e.g. as in vb.net MYDAYS_MONTH = DateTime.DaysInMonth({?Year}, {?Month}))Try Day(Datefield)

MOM Subscription errors

I have a few MOM reports that give the following error when I try to
set up a new subscription. I have previously been able to subscribe to
the reports, but now we get this error.
"There is an error in XML document (1,50623)"
I have seen couple of other posts on this, but never an answer or
solution. I can open and run the report in Visual Studio, but even if I
republish them to another folder they still fail. I can see the error
in the logs telling me I have an illegal character, but other than
validating the error, the log does not provide useful info.
THis is happening on more than one MOM report, but only on MOM reports.
Anyone know what is happening'?Had to contact MS. Of course there is a bug that requires a HOT FIX
that needs to be run on the MOM server. Turns out somehow there are
non-printable characters being populated in the data the reports are
using for paramaters to the reports.
The RS log files shows that there is an illegal character but does not
tell you where it is. I finally stumbled upon the illegal character
when looking at the drop down list boxes on the reports. They are of
course non-printable characters so you will not see them in the results
of a SQL select statement.
Here is the article that outlines the problem.
http://support.microsoft.com/?id=915785#XSLTH3120121123120121120120
Article ID : 915785

MOM Alert when login failed for user 'sa'

I am trying to setup a MOM Alert when the SA account fails to login to SQL,
How can this be setup so SQL reports this into the windows event viewer and
not its own log?
Many thanks for any help,
AlastairIt does get logged in the application event log whenever login failure
happens for any account. (Standard install)
However, you can create a rule in MOM to capture error id:18456 with error
desc like "Login failed for user 'sa'".
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"alastairn" wrote:
> I am trying to setup a MOM Alert when the SA account fails to login to SQL,
> How can this be setup so SQL reports this into the windows event viewer and
> not its own log?
> Many thanks for any help,
> Alastair
>|||Thanks for the fast response and help :)
"Saleem Hakani" wrote:
> It does get logged in the application event log whenever login failure
> happens for any account. (Standard install)
> However, you can create a rule in MOM to capture error id:18456 with error
> desc like "Login failed for user 'sa'".
> --
> Thank you,
> Saleem Hakani
> HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
> SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
> Articles, SQL Clinic and a lot of SQL fun.
>
> "alastairn" wrote:
> > I am trying to setup a MOM Alert when the SA account fails to login to SQL,
> > How can this be setup so SQL reports this into the windows event viewer and
> > not its own log?
> >
> > Many thanks for any help,
> > Alastair
> >

MOM 2005 Reporting error

Hi

I m using MOM 2005 SP1 FR with MSSQL 2000 SP3 and i get this error on one of my reports :

Erreur de Reporting Services
--
Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted) Obtenir de l'aide en ligne
Impossible de lire la ligne de donnes suivante pour le dataset PerfAnalysis. (rsErrorReadingNextDataRow) Obtenir de l'aide en ligne
La conversion d'un type de donnes CHAR en type DATETIME a donn une valeur hors des limites des valeurs de date et d'heure.

--
Microsoft Reporting Services

What can i do, i think i must edit xml file ?

Regards.

I have exactly the same problem !
Did anyone have an idea ?

Regards.

MOM 2005 Reporting error

Hi

I m using MOM 2005 SP1 FR with MSSQL 2000 SP3 and i get this error on one of my reports :

Erreur de Reporting Services
--
Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted) Obtenir de l'aide en ligne
Impossible de lire la ligne de donnes suivante pour le dataset PerfAnalysis. (rsErrorReadingNextDataRow) Obtenir de l'aide en ligne
La conversion d'un type de donnes CHAR en type DATETIME a donn une valeur hors des limites des valeurs de date et d'heure.

--
Microsoft Reporting Services

What can i do, i think i must edit xml file ?

Regards.

I have exactly the same problem !
Did anyone have an idea ?

Regards.