Reporting Services 2008 URL Parameters for SharePoint Integrated Mode

Passing URL report parameters directly to a report in a SharePoint Document Library is enabled in the SQL Server Reporting Services 2008 Integration with SharePoint Add-in.  

Examples: Here are examples using the Adventureworks sample reports assumed to be stored in SharePoint document library: http://<SharePoint_site>/Reports/ReportsLibrary·         Render the AdventureWorks “Employee Sales Summary” report for ‘Syed Abbas’ for ‘January’ / ‘2004′ with ReportViewer Toolbar showing pagination only: http://<SharePoint_site>/Reports/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/Reports/ReportsLibrary/Employee%20Sales%20Summary.rdl&rv:ToolBar=Navigation&rp:EmpID=288&rp:ReportMonth=1&rp:ReportYear=2004·         Render the AdventureWorks ‘Product Catalog’ report with the Document Map Area collapsed and no Header Area: http://<SharePoint_site>/Reports/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/Reports/ReportsLibrary/Product%20Catalog.rdl&rv:HeaderArea=None&rv:DocMapMode=Collapsed

ReportViewer parameters for controlling full-page report rendering

 

ReportViewer Parameter Description Values
rv:HeaderArea Control how the ReportViewer web part’s header is displayed in full-page view. Full, None. Default: Full
rv:ToolBar Control how the ReportViewer web part’s toolbar is displayed in full-page view. Full, Navigation, None. Default: Full
rv:ParamMode Control how the ReportViewer web part’s header is displayed in full-page view. Full, Collapsed, Hidden.Default: Full
rv:AsyncRender Control whether the report is rendered asynchronously or synchronously. true, false.
Default: true
rv:DocMapAreaWidth Control the display width in pixels of the ReportViewer web part’s Document Map area. Non-negative integer
rv:DocMapMode Control the display of the Document Map area of a report. Displayed, Collapsed, Hidden.
Default: Dislayed

 

  

About the Author