Solved

SQL 2012 Report Builder Share report

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

Title # Comments Views Activity
SSRS - Select nth row of dataset 4 172
SSIS needs with free express edition? possible? 2 66
SSRS Dynamic Column Names 3 68
SSRS Dynamic Date Parameter 25 371
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

831 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