When manually moving a SQL Reporting report from one environment to another, you may encounter the “The item ‘[/reportfolder/reportname]’ cannot be found. (rsItemNotFound)” issue. Most of the technical blogs will lead you to believe there is a permission problem on the file. While that may be true, we have experienced something different.
When you deploy a SQL Report from Visual Studio to a target repository, it creates a GUID to bind it to that environment. If you copy the RDL file off that system and attempt to manually put the file in another system, you need to remove the following section of the RDL file, else you will get the error.
Look for a reference, typically at the bottom of a file, formatted as follows:
<rd:ReportID>395484f8-dea9-44d0-8efb-5f397b4b2a76</rd:ReportID>
Remove this reference, manually upload the file to the reporting server, and hook up your data sources. It should resolve the issue.
