nitayalevette
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.
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).
ASKER
does this include scheduling? Are RDL's necessary in order to schdule a report?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i think yes you can update
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.