Solved

SQL 2012 Report Builder Share report

Posted on 2014-10-31
2
228 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

752 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