List Reports

Listing reports

You can get the list of reports in a given folder by using this SQL:

SELECT ReportId, ReportName FROM Report WHERE FolderId = 1

You can see if a user has access to a report by using this SQL:

declare @Ret int;
EXEC @Ret = CanUserViewReport @ReportId = 1569, @UserId = 1;
select @Ret

Code behind for ReportList.aspx:

VB.NET | C#