Solved

SQL 2012 Report Builder Share report

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

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…
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
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…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

679 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