Running SSRS SQL 2008 with SharePoint 2007 in Integration mode. I want to pass a URL parameter to the RSViewerPage.aspx in SharePoint site to export the rdl to PDF or XLS automatically. I was able to pull off going directly to the reportsever URL, but would like to do the same with SharePoint site. Any ideas? Thanks in Advance.

Correct me if I am wrong in understanding your requirement , Have you tried data driven subscriptions which will export rdl into PDF or excel format to Sharepoint site, instead of passing URL. Below link will provide some more info http://technet.microsoft.com/en-us/library/bb283186.aspxNanda

Was hoping to do this on-demand when it is clicked from the application. The report is an invoice and I would rather not give the users the ability to export to word or excel for editing. Currently I have an IIS site for sharepoint(SSL) then a separate one for SSRS(http), causing a second auth by users, if they access http://servername/reportserver. I guess an alternative is to have the SSRS virutal dirs inside the same IIS application site. Thoughts?

Crap, Forgot that SSRS 08 doesn't rely on IIS to host report manager and virtual dirs. Any other ideas?

Hi onethird13, I also do some test in my local environment, I could pass parameter value to the report by specifying the prefix "rp:", it works correctly. http://<SharePoint_site>/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/<SharePoint_Document_Library>/<Report_Name>.rdl&rp:Year=2001 I charge the URL to below: http://<SharePoint_site>/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/<SharePoint_Document_Library>/<Report_Name>.rdl&rp:Year=2001&rs:Format=PDF However, this URL does not export the report to PDF, just have the same effect as the first URL.It seems we could only use URL access parameter to change default report parameter values or to change the default report-viewer rendering experience in the full-page view of the report. To work around the issue, you could still export the report to PDF correctly via report server site not sharepoint site, just add &rs: Format=PDF to the URL. I have post this issue to the Reporting service Discussion Group, I think product team members or other senior engineers will give some explanation about this issue. Form more information about Passing URL report parameters to Reports in SharePoint Document Library in SSRS 2008 & R2, please see: http://blogs.msdn.com/b/prash/archive/2009/01/21/passing-url-report-parameters-to-reports-in-sharepoint-document-library-in-ssrs-2008.aspx?CommentPosted=true#commentmessage Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Also, have you considered rendering reports against the Report Server proxy? This proxy sits under the SharePoint site in the virtual directory /_vti_bin/ReportServer. For example, if you have a SharePoint site https://mysharepointsite, you can access the Report Server proxy at https://mysharepointsite/_vti_bin/ReportServer. So if you want to export a report to PDF, you can do something like: https://mysharepointsite/_vti_bin/ReportServer?https://mysharepointsite/mydoclib/myreport.rdl&rs:Command=Render&rs:Format=PDF

To work around the issue, you could still export the report to PDF correctly via report server site not sharepoint site, just add &rs: Format=PDF to the URL. Hi Tristan, Thanks for your reply; it is true we could render report via Report server proxy, just as my top reply. However customer want to export the report to PDF from SharePoint site, based on my Consulting, it does not work using the &rs: Format=PDF in SharePoint site directly, in SharePoint site, we could only use URL access parameter to change default report parameter values or to change the default report-viewer rendering experience in the full-page view of the report. Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thnx, this helped me a lot! Exactly what I needed.