January 2010 - Posts


Happy new year to everyone, sorry for the delay in my blogs as I have had family matters to attend to over christmas

Thanks as well for the many well wishes I have recieved about the MVP award I have recieved, it is truly an honour.

Last year I was asked by a number of people about allowing end users to take control of data driven subscriptions in SQL Server Reporting Services

I put forward the suggestion through Microsoft Connect and got the response below

Data driven subscriptions enables report server admininstrators to control the subscriptions that are created within reporting Services. This involves the creation of a table within SQL Server that holds the subscription information that is queried when a data driven subscription is executed, As a result administrators create and set up data driven subscriptions.

I have been asked if this feature could be provided to trusted business users to manage, freeing up report server administrators time to concentrate on other Administration issue.


Here is the response

"Greetings from Microsoft Connect!

This notification was generated for feedback item: Enabling Data Driven Subscriptions to be Managed by Power Users which you submitted at the Microsoft Connect site.

Thank you for filing this issue. We will look at it as a potential design change for a future version.

In the meantime, there are sevearl things you could do to work around this on your side, or provide such a UI.

First, creating and managing data driven subscriptions is determined by the Report Server Manage Any Subscription permission. I know your request is to have a dedicated role. However, it can still be possible to assign the existing role to the appropriate users on the appropriate items in RS.

Second, I believe you want the business power user to be able to enter the rows of data that the delivery query will return from a web UI. There are several way of accomodating this. Option one is if you are using SharePoint Integrated Mode, the user could put the data in a SharePoint List and then use the list as a data source. A SharePoint List data extension will ship with SQL Server 2008 R2 Reporting Services and works when you are in SharePoint Integrated Mode (available first half 2010). Option two is to roll your own UI page that stores the user's values as an XML file which is exposed by a webservice. Our existing XML data extension can connect to the web service and retrieve the data. You would probably need to provide a custom UI application which enabled this more easily. You can follow this same pattern using an Atom ata Feed with the XML data extension.







Posted by Testas | 5 comment(s)