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 |