Hi, Im facing problem in passing report paramter over url. Can any1 help me. Im using ssrs2005. I think this feature is not enabled in ssrs 2005 but enabled in ssrs 2008. SSRS is confiured with sharepoint integration mode. Please help me out foe passing parameter to reportviewer over urlMahender

http://msdn.microsoft.com/en-us/library/ms155391.aspx - Kerobin

Hi Mahender, To this issue, please refer to Russel's professional blog about How to use URL Access in Reporting Services SharePoint integration mode at this link http://blogs.msdn.com/b/bimusings/archive/2007/02/24/how-to-use-url-access-in-reporting-services-sharepoint-integration-mode.aspx Thanks, Challen Fu

Hi Challen, Thnx for url, I used same approach, for passing parameters to report server ,it worked excellent. But the problem is report is shown in SSRS reportviewer but not by sharepoint reportviewer, I require sharepoint look and feel when users execute his/her report which is similar to rsviewerPage.aspx. Anyway i fix my problem with little tweaking of RsViewerPage. Here is the code protected override void OnLoad(EventArgs e) { base.OnLoad(e); string content = string. Empty; if (!Page.IsPostBack) { ReportParameterDefaultCollection parameters; parameters = m_sqlRsWebPart.OverrideParameters; foreach (string urlParam in Request.QueryString.AllKeys) { if (urlParam != null) { if (Request.UrlReferrer != null) { try { content = "Sample"; //Dummmy Text or any logic tht u have implement inorder to retrieve the string data; } catch (Exception ex) { content = String.Empty; } } string paramName = "PortalSite"; //urlParam.Substring(8); string paramValue = content; Microsoft.Reporting.WebForms.ReportParameter p = new Microsoft.Reporting.WebForms.ReportParameter(paramName, paramValue); parameters.Add(p); } } } } Mahender