Solved

SQL Server 2005 Report Server Database

Posted on 2010-08-24
6
251 Views
Last Modified: 2012-05-10
Does SQL Server 2005 allow manual inserts into the reporting server database?  I would like to populate the necessary tables/columns in the reporting database and have reports scheduled and executed without going through reporting services.  
0
Comment
Question by:nitayalevette
[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
  • 3
  • 2
6 Comments
 
LVL 12

Expert Comment

by:mcv22
ID: 33515172
The reporting services database schema isn't documented and frequently changes between versions. Having said that, you do have an option to programatically generate report definition files (refer to : http://msdn.microsoft.com/en-us/library/ms170667%28v=SQL.90%29.aspx).
0
 

Author Comment

by:nitayalevette
ID: 33515825
does this include scheduling?  Are RDL's necessary in order to schdule a report?
0
 
LVL 12

Accepted Solution

by:
mcv22 earned 250 total points
ID: 33516030
You can use reporting services scripting language to create an rss file:

http://odetocode.com/articles/114.aspx

Another way to do it would be through SQL management studio. Create a subscription all the way until the last step. Then click on script to file. Refer to http://msdn.microsoft.com/en-us/library/ms152908%28v=SQL.90%29.aspx on how to run rss files.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 9

Expert Comment

by:sureshbabukrish
ID: 33519209
i think yes you can update
0
 

Author Comment

by:nitayalevette
ID: 33520873
I'm looking for an automated way to create the reports.  I think I want to create the RDL, and then insert the schedule with a script or code.  Which tables in the reporting database do I have to update to have an automated report delivered?
0
 
LVL 12

Assisted Solution

by:mcv22
mcv22 earned 250 total points
ID: 33523652
For the schedules, following are some of the tables that will need modifications for sure (there might be more): ActiveSubscription, Notifications, ReportSchedule, Schedule, Subscriptions. You will also need to set up a job and modify the corresponding columns in these tables to update with the job name generated.

I would advise creating a test subscription and have SQL profiler running the background to make sure that you don't miss anything.
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

730 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