How To Retrieve the Report Author

In SQL Server Reporting Services (SSRS), the information about the report author is typically stored in the ReportServer database. You can retrieve the report author by querying the relevant tables in the ReportServer database. Here's a simple SQL query to get the report author from SSRS:

```sql

USE ReportServer;

SELECT

C.Path AS ReportPath,

C.Name AS ReportName,

C.CreationDate AS ReportCreationDate,

U.UserName AS ReportAuthor

FROM

Catalog AS C

INNER JOIN Users AS U ON C.CreatedByID = U.UserID

WHERE

C.Type = 2; -- Type 2 corresponds to reports in SSRS

-- Optionally, you can add more conditions to filter the results based on your requirements.

```