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.
Marty Zigman
Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.
More Posts - Website - Twitter - Facebook - LinkedIn - YouTube
