How To Display Reports On A Sharepoint Zone Other Than The Default Zone

Most developers running SharePoint in integrated mode have been experincing issues when displaying SRS reports in a web site other than the default zone.
There is a blog http://www.sharepointblogs.com/nrdev/archive/2007/06/21/ssrs-in-sharepoint-2007-site-using-forms-based-authentication-sharepoint-integrated-mode.aspx that explains that this is a bug and may be fixed when SP3 is released.

We are usi ng dual authentication for a particular site that hosts SRS reports and the default zone is windows auth and the internet zone is FBA. Since we cannot display reports using the RSViewerPage.aspx that comes with RS sharepoint addon, I decided to look for some way to display these reports in a non default zone. This method may help those experincing ths issue but the method assumes that you have one default zone or default zone [0] is the zone where reports are deployed from Visual Studio.

Here are the steps.
1. Go to your Layouts/reportseerver folder in your MOSS installation.
2. make a backup of RSViewerPage.aspx
3. Open RSViewerPage.aspx in visual studio and on the header declarations change the following line that looks like
<%@ Page language="C#" Codebehind="RSViewerPage.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.SharePoint.UI.RSViewerPage,Microsoft.ReportingServices.SharePoint.UI.ServerPages,Version=9.0.242.0,Culture=neutral,PublicKeyToken=89845dcd8080cc91" %>

to

<%@ Page language="C#" AutoEventWireup="false" %>

4. Add the following script line to the page

<script runat="server">
protected override void OnLoad(EventArgs e)
{
SPSite site = SPContext.Current.Site;
if (!Page.IsPostBack)
{
String RelativeReportUrl = Request["RelativeReportUrl"];
if (site.Zone != SPUrlZone.Default)
{
foreach (SPAlternateUrl url in site.WebApplication.AlternateUrls)
{
if (url.UrlZone == SPUrlZone.Default && RelativeReportUrl != null && url == site.WebApplication.AlternateUrls[0])
{
String path = url.Uri.AbsoluteUri.Substring(0, url.Uri.AbsoluteUri.Length - 1) + RelativeReportUrl;
m_sqlRsWebPart.ReportPath = path;
}
}
}
else
{
m_sqlRsWebPart.ReportPath = site.Url + Request["RelativeReportUrl"];
}
}
//add nav
SiteMapPath map = new SiteMapPath();
map.SiteMapProvider = "SPSiteMapProvider";
map.RenderCurrentNodeAsLink = true;
m_breadCrumbs.Controls.Add(map);
}
</script>

5. This script section just points the web part in the RSviewerPage to the report file hosted in the MOSS default zone.

Thats it.

This should work in either of the MOSS zones.

Gatharia