Link to home
Start Free TrialLog in
Avatar of nitayalevette
nitayalevetteFlag for United States of America

asked on

SQL Server 2005 Report Server Database

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.  
Avatar of mcv22
mcv22
Flag of United States of America image

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).
Avatar of nitayalevette

ASKER

does this include scheduling?  Are RDL's necessary in order to schdule a report?
ASKER CERTIFIED SOLUTION
Avatar of mcv22
mcv22
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
i think yes you can update
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?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial