[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL 2012 Report Builder Share report

Posted on 2014-10-31
2
Medium Priority
?
261 Views
Last Modified: 2014-11-03
I am running SQL 2012.  I have made some rpeorts in SQL Report Builder.  I want an easy way to schedule a run of the rpeorts and then export them to pdf into a file folder.  Is their an easy way to do this?
0
Comment
Question by:PeelSeel2
2 Comments
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 2000 total points
ID: 40417018
This can be done by subscriptions. But you need SQL Standard or higher for that.
http://msdn.microsoft.com/en-us/library/ms159762(v=sql.110).aspx

With SQL Express it's not easy. You need to write some code that retrieves the report and stores it in a file. The starting point for this is getting the right url's to retrieve the reports. See:
http://msdn.microsoft.com/en-us/library/ms153586(v=sql.110).aspx
http://msdn.microsoft.com/en-us/library/6a3b7fc3-3d91-4d12-8371-42ea12e74517(v=sql.110)
0
 

Author Closing Comment

by:PeelSeel2
ID: 40419743
Thank you.  I have SSRS standard 2012.  So I installed it.  Now I am having different issues;  another question for that!
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question