Dan Kowalski
asked on
What is a good third party tool that will help manage SSRS report subscriptions?
I am looking for a good third party tool that will help manage SSRS report subscriptions. We want to expose this to our business users so that they can manage their subscriptions as well as client subscriptions. Is there anything out there right now that can help with this particular requirement?
If you still need a tool you can explore this tool - It is called SSRS Subscription Manager- http://www.2ndrock.com/
ASKER
My manager wants a tool that we can expose to the business users that will not have experience with SSRS or SSMS. He wants a tool that can allow business users to update reports they are subscribed to as well as update client reports that we have in our system.
Also thank you for the link to that tool. I will review that tool. Are there any others that might get the job done?
Also thank you for the link to that tool. I will review that tool. Are there any others that might get the job done?
Another tool i know is report builder. Please check.
ASKER
Will the report builder help manage subscriptions or just help export and update report fields and things like that?
I think report builder does not manager subscriptions. So lets leave this.
@Author - do you need more help with this? If not could you please select the answer and close the question.
The easiest is to let your users access your report server directly via HTTP (http://yourServer/Reports/Pages/Folder.aspx). As long as you give them sufficient permissions, they can set up their own subscriptions with no development work on your part, just a little training so they know where to click.
If you have SQL Server Enterprise Edition you can use "Data-Driven Subscriptions" (DDS), but I assume if you're asking that you're on Standard Edition (like poor me). DDS allows you to easily manage subscriptions using Active Directory or simple tables - add someone's email to the table and they get the report. I don't have access to subscription information through SSMS without Enterprise Edition. If you do have Enterprise and didn't know DDS existed, here's a doc on it.
Otherwise, here's a non-free tool that is supposed to bolt DDS onto SQL Standard, but I haven't tried it and there are certainly others like @pawan suggested:
ChristianSteven.com
If you have SQL Server Enterprise Edition you can use "Data-Driven Subscriptions" (DDS), but I assume if you're asking that you're on Standard Edition (like poor me). DDS allows you to easily manage subscriptions using Active Directory or simple tables - add someone's email to the table and they get the report. I don't have access to subscription information through SSMS without Enterprise Edition. If you do have Enterprise and didn't know DDS existed, here's a doc on it.
Otherwise, here's a non-free tool that is supposed to bolt DDS onto SQL Standard, but I haven't tried it and there are certainly others like @pawan suggested:
ChristianSteven.com
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
SSMS >> Connection Object Explorer >> Reporting Services > Servername
Its a good tool , you can do lot of things .. try it once.