SharePoint Pals
 | Sign In
Manage SSRS Report Parameter(s) and Report Subscription in SharePoint Integrated Mode – Part 2
by Moses Pakkianathan 15 Jun 2013
Author
SharePoint Consultant
Visits   
Today  :   10     Total  :    17673

 

This is continuation of my previous article that dealt with the Smart & Smarter side of Report Parameters in SQL Reporting Services – SharePoint integrated mode. We had already covered the basics in SSRS Report Parameters from Report level & went on with the cascading style of report parameters in SSRS at report level. In this article we’ll cover the Smartest side of Report Parameter & Report Subscription.

 

Report Parameters – SSRS in SharePoint Integrated Mode

Parameters are used when data needs to be narrowed down. Not all the data source in SSRS support parameters, in such scenario we can use Report Parameters to help users at Report level. These report parameters can be managed after being published based on how it is configured. There are many ways to narrow down, lets categorize it by: Smart, Smarter and Smartest.

For Smart & Smarter mode, please visit this link.

 

Smartest mode

Report parameters can be passed directly in the URL which could be helpful for non-default parameters. These commands could be categorized to three levels: Report Viewer Web Part commands, Report Server command and HTML Viewer commands. For SharePoint integrated mode, we’ll consider Report Viewer Web Part commands.

In Report Viewer Web Part, following reserved report parameters can be used by prefixing rv: to the parameter names.

  • rv:toolbar

This parameter controls the toolbar display for Report Viewer Web Part. Full is used for complete display of toolbar and this is the default value, Navigation would be used to display only the pagination control in the toolbar or None can be used to hide the toolbar

ex. http://<SharePoint_site>/Reports/_layouts/ReportServer/RSViewerPage.aspx?rv:toolbar=None

  • rv:headerarea

This parameter controls the header display for Report Viewer Web Part. Full is used for complete display of header and this is the default value, BreadCrumbsOnly would be used to display only the bread-crumb navigation control in the toolbar or None can be used to hide the header

ex. http://<SharePoint_site>/Reports/_layouts/ReportServer/RSViewerPage.aspx?rv:headerarea=BreadCrumbsOnly

  • rv:docmapareawidth

This parameter controls the width of parameter area in Report Viewer Web Part. Value should be a non-negative integer and width value will be in pixels

  • rv:docmapmode

This parameter controls the display of document map area in Report Viewer Web Part. Value would be Full (default), Collapsed or Hidden

  • rv:parammode

This parameter controls the display of parameter prompt area in Report Viewer Web Part. Value would be Full (default), Collapsed or Hidden

  • rv:docktoolbar

This parameter controls the display position of toolbar in Report Viewer Web Part. Value would be Top (default) or Bottom

  • rv:toolbaritemsdisplaymode

This parameter controls the items that are displayed in the toolbar of Report Viewer Web Part. Values for this parameter is quite different from others, here we’ll have to sum-up the value of the desired items. For ex. if we need only Refresh & Zoom button, the value would be 8+16 = 24

-1 = All toolbar items

1 = Back button

2 = Text search

4 = Page navigation

8 = Refresh

16 = Zoom

32 = Atom feed

64 = Action button with Print option

128 = Action button with Export option

256 = Action button with Open with Report Builder option

512 = Action button with Subscribe option

 

Subscriptions – SSRS in SharePoint Integrated Mode

Subscription can be used to deliver reports to SharePoint Document Library or to E-mail or to Shared Folders. On the delivered files few privileges will be missing, like drilldown links. Before enabling subscription, try to render the reports in different format and chose the delivery option that has all your output requirements.

If while delivering thru email, only the notification link is required sans the report, then clear the Include a Link to this report and Show report inside messages checkbox

 

  • Select the library that has your reports and select the dropdown from the report that requires subscription

clip_image001

  • Select Add Subscription

clip_image002

  • For a file to be delivered to a Shared Folder, choose ‘Windows File Share’. Other configurable items are marked in the below diagram

clip_image003

  • For a file to be delivered to a SharePoint Document Library, choose ‘SharePoint Document Library’

clip_image004

  • To configure the schedule option, click on Configure button & fill the schedule details

clip_image005

  • Parameter values can be configured based on the subscription requirement

clip_image006

This completes our Report Parameters and Subscription model for SQL Reporting Services – SharePoint Integrated Mode.

blog comments powered by Disqus

SharePoint Pals

Pals
SharePoint Pals, a community portal for SharePoint developers, Administrators and End Users. Let's join hands and share the point together.
Read this on mobile

Training

Angular Js Training In Chennai
Advanced Angular Js training with real world developer scenarios
Angular Js, Web Api and Ionic for .Net Developers
All in one client side application development for .Net developers
Angular Js For SharePoint Developers
Get ready for the future. Its no more just C#

Get Connected

SharePoint Resources

SharePoint 2013 and 2010 Web Parts
Free Web Parts with Source Code for SharePoint Community




SharePoint 2013 Books and Tutorials
Collection of free SharePoint 2013 books and tutorials (eBooks, pdfs)

Supported By

Contribute your article and be eligible for a one month Free Subscription for Plural Sight. The Author of the most popular New Article (published in the previous month) will be awarded with a Free One month Plural Sight Subscription. Article can be sent to articles@sharepointpals.com in a word document.

Related Resources

Recent Tweets

Twitter January 15, 00:25
How To Enable Target Value And Actual Value In #D3 Gauge Chart https://t.co/VxSi4QnNrC

Twitter January 15, 00:24
How To Open #SharePoint List Hyperlink Column In Modal #Popup Window https://t.co/EQ7HkoZDkX

Twitter January 15, 00:24
Quick Introduction To #Asp.NetCore And It’s Features https://t.co/zAXObHCFpH

Twitter January 15, 00:22
How To Configure #PerformancePoint Services To Use Secure Store In #SharePoint 2013 https://t.co/LEwnUoI7EY

Twitter January 15, 00:21
How To Block Or Disable #Office365 Services https://t.co/Yvp2VPFIRP

Follow us @SharePointPals
Note: For Customization and Configuration, CheckOutRecent Tweets Documentation