Solved

SQL 2012 Report Builder Share report

Posted on 2014-10-31
2
218 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 500 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

862 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now