In order to find out which web reports belong to which permission groups, the following T-SQL may be run to dicsover which roles will grant access to a report:
DECLARE @reportTitle VARCHAR(MAX) = 'Debit Memo'
DECLARE @rptId varchar(MAX),@pGroup varchar(MAX)SELECT @rptId = rptID,@pGroup = paramGroup FROM [MnxReports] WHERE rptTitle LIKE '%'+ @reportTitle +'%'SELECT rptId,rptTitle,rptTitleLong,
Simply change the 'Debit Memo' to the title of the report you want.