Problem With A Chart In Reporting Services

I am trying to display a chart from a data source that runs a stored procedure. The data dislays fine in the dataset tab, however, when I try to preview the report I get the following message:

'An error occurred during local report processing. The definition of the report 'reportname' is invalid. An internal error occured on the report server. See the error log for more details'.

I have looked at the error logs, but they do not help. I am thinking that my stored procedure is pushing a limit of the chart report. If I display the same data in a table, it displays fine, it is only in a chart. As I stated, the data is displaying in the dataset grid.

Can anyone give me an idea as to what my problem might be? I have other charts that run fine, but not using a stored procedure like the one below where I am performing multiple selects.


Below is the stored procedure:


set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author: Tim Olig

-- Create date: 09/20/07

-- Description: Returns Total Stored Procedure

-- =============================================

ALTER PROCEDURE [dbo].[sp_db_ReturnsSummary]

@Date smalldatetime



AS

BEGIN

SET NOCOUNT ON;



Select rtsum.FiscalYear,rtsum.Period,

rtsum.RMAComplete_ALL,

rtsum.RMAComplete_ANO,

rtsum.RMAComplete_EXT,

rtsum.RMAComplete_FAB,

rtsum.RMAComplete_SUN,

rtsum.RMAComplete_SUP,

salessum.ShipRev

from





(SELECT

CASE WHEN datepart(YY,returns.invdate) = 1900 then 2008 else datepart(YY,Returns.Invdate) end as FiscalYear,

CASE WHEN datepart(YY,returns.invdate) = 1900 then 'PENDING'

WHEN len(datepart(mm, returns.invdate)) = 1 THEN 'P0' + ltrim(str(datepart(mm, returns.invdate)))

WHEN len(datepart(mm, returns.invdate)) = 2 THEN 'P' + ltrim(str(datepart(mm, returns.invdate))) END AS Period,



"RMAComplete_ALL" = sum(returns.TotalCredit),

"RMAComplete_ANO" = sum(case when returns.respdept = 'ANODIZING DEPT' then (returns.TotalCredit) else 0 end),

"RMAComplete_EXT" = sum(case when returns.respdept = 'EXTRUSION DEPT' then (returns.TotalCredit)else 0 end),

"RMAComplete_FAB" = sum(case when returns.respdept = 'FAB' then (returns.TotalCredit) else 0 end),

"RMAComplete_SUN" = sum(case when returns.respdept = 'SUNROOF' then (returns.TotalCredit) else 0 end),

"RMAComplete_SUP" = sum(case when returns.respdept = 'SUPPLIER' then (returns.TotalCredit) else 0 end)



FROM [returns]

WHERE invfiscalyear = 1990 or returns.invdate >= @Date

group by datepart(YY,Returns.Invdate), CASE WHEN datepart(YY,returns.invdate) = 1900 then 'PENDING' WHEN len(datepart(mm, Returns.invdate)) = 1 THEN 'P0' + ltrim(str(datepart(mm, Returns.invdate))) WHEN len(datepart(mm, Returns.invdate)) = 2 THEN 'P' + ltrim(str(datepart(mm, Returns.invdate))) END)

as rtsum



left outer join

(select

datepart(YY,transdate) as FiscalYear,

CASE WHEN len(datepart(mm,transdate)) = 1 THEN 'P0' + ltrim(str(datepart(mm,transdate)))

WHEN len(datepart(mm,transdate)) = 2 THEN 'P' + ltrim(str(datepart(mm,transdate))) END AS Period,

"ShipRev" = sum(case when (OrderType = 'Invoiced' or OrderType = 'ToBeInvoiced') and SalesAcctDesc = 'Sales' then Revenue else 0 end)



FROM sforep where transdate >= @Date

group by datepart(YY,transdate), CASE WHEN len(datepart(mm,transdate)) = 1 THEN 'P0' + ltrim(str(datepart(mm, transdate))) WHEN len(datepart(mm, transdate)) = 2 THEN 'P' + ltrim(str(datepart(mm, transdate))) END)

as salessum

on rtsum.fiscalyear = salessum.fiscalyear and rtsum.period = salessum.period

END




Thanks,

Tim Olig