We had several reports that worked fine in SSRS for months and months. Suddenly the report has stopped work and has the oddest message. We've narrowed down the issue to the fact that 2 tables can't join suddenly. In its simplest the join is:
FROM View_Endowment_Summary_Report as TP INNER JOIN tempTableEP AS ESR ON
TP.ProjectID = ESR.ProjectID
The error that comes up is that it has failed converting the varchar value 'Endowed' to data type int. The problem is that it is joining on a number such as 88435 and has nothing to do with 'Endowed'. (Endowed is a value in another column, but isn't part of the join). I have no clue what has suddenly created this problem or better yet how to fix it. We are on service pack 3, or I'd apply a new SP. Help!!!!