Tuesday, March 20, 2012

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?

Ana9,

You will find the log files \\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\Logfiles

Ham

No comments:

Post a Comment