Hi All, We have the SSRS 2008 report deployed in the SharePoint 2007 integration mode. We have a main report and we are trying to use the drill down report which should open a detail report with the parameter value passed. I am not able to pass the parameter value to the URL The below url is working fine for the detail report but this opens a blank report with no parameter value. http://sitename/reportdocumentlibrary/TestReport.rdl When I try to pass the parameter value then I am getting error http://sitename/reportdocumentlibrary/TestReport.rdl?UniqueMeterKey=232&Date=05/01/2011 Please let me know how we can make this working. Thanks, Gaurav http://gauravsqlserver.blogspot.com

Hi All...Any idea on this?Thanks, Gaurav http://gauravsqlserver.blogspot.com

Hi Gaurav, URL access is used for URL on report server rather than the URL on SharePoint site, so you could not pass the value to your SharePoint URL, this is the root cause. If you want to achieve this requirement, Here’s an example using the following assumptions: 1. SSRS itself is installed on a machine called SSRSServer 2. MOSS is installed on MOSSServer 3. The report “DemoReport” is stored in a report library named “ReportLibrary” Your report's URL on report server should be: http://SSRSServer/reportserver?http://MOSSServer/ReportLibrary/DemoReport.RDL If you want to pass parameter value, the URL should be: http://SSRSServer/reportserver?http://MOSSServer/ReportLibrary/DemoReport.RDL&UniqueMeterKey=232&Date=05/01/2011 Please make sure 232 and 05/01/2011 are the correct format value for your report. Thanks, Challen Fu

Hi Challen..this is not working. I am assuming here the SSSR server you mean is the SSRS server which is used to install the SharePoint in integration mode. when I open this server http://SSRSServer/ReportServer then I do not see any of the report deployed here and I am assuming the reason for that is because we have deployed the reports in the SharePoint document library. Please let me know if anything I am doing wrong here?Thanks, Gaurav http://gauravsqlserver.blogspot.com

Hi Gaurav 17, Just as you mentioned you have deployed the reports in one of the SharePoint document library, so you cannot see the report when you open the http://SSRSServer/ReportServer URL, if your SSRS server and SharePoint Server is on the same computer, your report on the Report Server's URL should be http://Servername/reportserver?http://ServerName/ReportDocumentLibrary/DemoReport.RDL Note: Please replace the Servername and ReportDocumentLibrary based on your environment. Then you could pass the parameter's value to the URL just like my first reply. Please notice again you cannot pass the parameter value to report's URL in sharepoint site just like this http://sitename/reportdocumentlibrary/TestReport.rdl Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

I found the solution for this http://sharepointserver/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/reports/meter%20details%20report.rdl&rv:Toolbar=None&rv:ParamMode=Hidden&rp:UniqueMeterKey=132&Date=5/20/2011&rv:HeaderArea=None Thanks, Gaurav http://gauravsqlserver.blogspot.com