I recently deployed SSRS 2005 in SharePoint integration mode for a client. I created a SharePoint list that I published the report RDL files too. When accessing the reports, I encountered a rather long error which contained the following: “T he specified path refers to a SharePoint zone that is not supported. The default zone path must be used” From reading on the web, this appears to be a bug with SSRS2005/SPI mode. What I ended up doing, was creating a webpage for each of the reports in my site, and each page used the SSRS ReportViewer web part (pointing to a specific report. These wepages are contained in a single SharePoint list (as shown below). Users can access the list from the main PWA menu, and once in the list can click directly on what appears to be the report (but is actually a webpage containing the report) and it generates successfully. Perhaps not the cleanest solution, however, it will suffice until 2010 is released
Figure 1. This is the menu to access the SSRS Reports
Figure 2. Here are the reports (Actually WebPages) shown after clicking on report menu from Figure 1.
Figure 3. Upon clicking on the “Report”, a webpage is opened, which uses the ReportViewer webpart. The ReportViewer webpart points to the report the webpage is named after.