I have a report that was working in my SSRS 2005 but the exact same code is not working in SSRS 2008.

The error I am getting is

An error occured during report processing. (rsProcessingAborted). Cannot read the next data row for dataset DSLLC.

Here is the query that is not working anymore.

SELECT SV00100.CPRCSTNM, max(SOPHisIt.CUSTNMBR), MAX(RM00101.CUSTNAME) AS Expr1, SUM(SOPHisIt.XTNDPRCE) AS TotalSales
FROM SOPHisIt INNER JOIN
SV00100 ON SOPHisIt.CUSTNMBR = SV00100.CUSTNMBR INNER JOIN
RM00101 ON SOPHisIt.CUSTNMBR = RM00101.CUSTNMBR
WHERE (SOPHisIt.USRDEF05 IN (200, 250)) AND (SOPHisIt.DOCDATE > GETDATE() - 365) AND sv00100.cprcstnm > '0'
GROUP BY SV00100.CPRCSTNM
ORDER BY TotalSales desc




SELECT SV00100.CPRCSTNM, max(SOPHisIt.CUSTNMBR), MAX(RM00101.CUSTNAME) AS Expr1, SUM(SOPHisIt.XTNDPRCE) AS TotalSales
FROM SOPHisIt INNER JOIN
SV00100 ON SOPHisIt.CUSTNMBR = SV00100.CUSTNMBR INNER JOIN
RM00101 ON SOPHisIt.CUSTNMBR = RM00101.CUSTNMBR
WHERE (SOPHisIt.USRDEF05 IN (200, 250)) AND (SOPHisIt.DOCDATE >= @StartDate) AND (SOPHisIt.DOCDATE <= @EndDate) AND sv00100.cprcstnm > '0'
GROUP BY SV00100.CPRCSTNM
ORDER BY TotalSales desc


Any help would be appreciated. When I run it in SSMS it runs fine.

Thanks in advance,

Zach Ungerman