Reporting Services keeps crashing!

I have two datasets, each of which are pretty much exactly alike. Each
dataset has a corresponding matrix on the report and thats all there is.
When I run each query they work fine but when i preview the report I get the
following:
An error occurred during local report processing. An internal error occurred
on the report server. See the error log for more details.
My query is as follows:
SELECT dbo.SR_Service.SR_Service_RecID,
CASE WHEN sr_type.description LIKE 'Internal' THEN sr_service_recid END AS
internal,
CASE WHEN sr_type.description LIKE 'Incident' OR
sr_type.description LIKE 'scheduled maintenance' OR
sr_type.description LIKE 'support email' THEN
sr_service_recid END AS incident,
CASE WHEN sr_type.description LIKE 'projects' THEN sr_service_recid END AS
project,
(SELECT period FROM TE_Period WHERE (CONVERT(varchar(10),SR_Service.
Date_Entered,101) BETWEEN TE_Period.Date_Start AND TE_Period.Date_End) AND
TE_Period_Setup_RecID =106) AS period
FROM dbo.SR_Service INNER JOIN
dbo.SR_Type ON dbo.SR_Service.SR_Type_RecID = dbo.
SR_Type.SR_Type_RecID
WHERE (DATEPART(yyyy, dbo.SR_Service.Date_Entered) = '2006')
ORDER BY period
I am able to run all the other reports I have created, including those with
subquerys.
What the heck could be making Reporting Services crash? Where can I even
find the error log?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200612/1Is this RS 2000 or RS 2005? Also, there is a difference between preview and
deployment. Just in case it is a bug in development that is not there when
deployed I would try deploying it and see if you still have the problem. I
once had an issue for a particular report that I just deployed and tested
that and didn't use the preview.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ana9 via SQLMonster.com" <u28955@.uwe> wrote in message
news:6b000255b0532@.uwe...
>I have two datasets, each of which are pretty much exactly alike. Each
> dataset has a corresponding matrix on the report and thats all there is.
> When I run each query they work fine but when i preview the report I get
> the
> following:
> An error occurred during local report processing. An internal error
> occurred
> on the report server. See the error log for more details.
> My query is as follows:
> SELECT dbo.SR_Service.SR_Service_RecID,
> CASE WHEN sr_type.description LIKE 'Internal' THEN sr_service_recid END AS
> internal,
> CASE WHEN sr_type.description LIKE 'Incident' OR
> sr_type.description LIKE 'scheduled maintenance' OR
> sr_type.description LIKE 'support email' THEN
> sr_service_recid END AS incident,
> CASE WHEN sr_type.description LIKE 'projects' THEN sr_service_recid END AS
> project,
> (SELECT period FROM TE_Period WHERE (CONVERT(varchar(10),SR_Service.
> Date_Entered,101) BETWEEN TE_Period.Date_Start AND TE_Period.Date_End) AND
> TE_Period_Setup_RecID =106) AS period
> FROM dbo.SR_Service INNER JOIN
> dbo.SR_Type ON dbo.SR_Service.SR_Type_RecID = dbo.
> SR_Type.SR_Type_RecID
> WHERE (DATEPART(yyyy, dbo.SR_Service.Date_Entered) = '2006')
> ORDER BY period
> I am able to run all the other reports I have created, including those
> with
> subquerys.
> What the heck could be making Reporting Services crash? Where can I even
> find the error log?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200612/1
>|||This is in RS2005. I also tried deploying it and I get another error
message saying it can't be deployed.|||I am using RS2005 and I also tried deploying it. I get a different error
when I try to deploy it.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200612/1|||Sorry, just tried it again and I get the same internal error message. I
tried to deploy the report from visual studio and to upload it directly,
neither of which worked.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200612/1|||I rebuilt the entire thing without previewing it and it deployed just fine.
Thanks for the help.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200612/1