how can i access report server database ?I've C# application and i want to develop a screen with a grid that loads all reports created on report server.
i know what stored proc to call in Reportserver database to get list of reports but I read a msdn article that says we should not be writing applications that run queries against the report server database.
"The report server database is not a public schema. The table structure might change from one release to the next. Always use the Reporting Services APIs to access the report server database."
my question is how can i use reporting service API to get list of reports ? any examples on this much appreciated.
Thank you very much for your helpYou may want to start reading the documentation about the SOAP API here:
http://msdn2.microsoft.com/en-us/library/ms152787.aspx
In your particular case, you want to use the ListChildren SOAP API method. An example can be found here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_intro_7vqa.asp
There is also a sample that installs with RS 2000 / RS 2005 which shows an application that uses the SOAP API to retrieve various types of information from the report server.
-- Robert|||Thats wonderful Robert.
Thats what am after :)|||
Great to hear it answers your questions. Please also mark answers if you think they are helpful - it will help other people to more easily find helful answers on this forum. Thanks.
-- Robert
No comments:
Post a Comment