all groups > sql server reporting services > february 2007 >
You're in the

sql server reporting services

group:

Why can't I run any reports?


Why can't I run any reports? Michael.Proyecto7
2/27/2007 2:51:38 PM
sql server reporting services:
This is probably something trivial, but I'm from an Oracle Unix environment
and I have no idea how to solve this in windows server 2003 with SQL Server
2005 sp1... it happens whenever I run any report.

An unexpected error occurred in Report Processing. (rsInternalError) Get
Online Help Specified cast is not valid.



Re: Why can't I run any reports? EMartinez
2/27/2007 8:02:29 PM
On Feb 27, 4:51 pm, Michael.Proyecto7
[quoted text, click to view]

Please post some of the query and/or report expressions. Just from
looking at the error, it might be that you need to convert a value to
a consistent datatype.

Enrique Martinez
Sr. SQL Server Developer
Re: Why can't I run any reports? Michael.Proyecto7
2/28/2007 5:52:11 AM
I can't access any report from within the .net environment. It appears that
I can't connect to the database, but when I use the connection configuration
tool I get another error... I can create new queries, but I can't view them
from within .net or from my http://localhosts/reports location.

It states "No report servers were found on the specified machines". These
reports worked a few weeks ago, until an update was done via the update tool,
and vooalaa. I tried uninstalling the updates but to no avail.

[quoted text, click to view]
Re: Why can't I run any reports? EMartinez
2/28/2007 7:49:19 PM
On Feb 28, 7:52 am, Michael.Proyecto7
[quoted text, click to view]

You probably want to check to see if you web server (IIS) has been
turned off. Right click my computer, go to Manage then open Service
and Applications and Internet Information Services. Right click it and
either start it or re-start it. This might be the problem.

Regards,

Enrique Martinez
Sr. SQL Server Developer
AddThis Social Bookmark Button