Where is the data (xml?) stored when a report is deployed?

Question

When I haved developed a Reporting Services report and deployed it to the server, where is the actual report stored? I'm guessing the SQL-database, but what table and in what format?

Answer 1

AFAIK, it is typically stored in the ReportServer database in the dbo.Catalog table.

The column type for dbo.Catalog.Content is image, so I don't believe you can directly query the table to get the report data (XML). You can use the various tables in other ways (Kick off report processing, look at schedules, find missed schedules etc...)