Report Properties in Repository

Ralf Zerfass

Hi,

I'm trying to extract a matrix from the repository which user has access to which report. That is requested from auditors and from management from time to time.

Doing this manually based on users, groups, roles and permissions is very time consuming, so I figured out some tables and stored functions in the repository to extract e.g. from coFolder, coReport and using sf_has_report_permission the necessary data.

Works fine but the only thing I'm missing is: Where is the property if a report is shown/hidden in a report viewer stored in the repository:

As hidden reports cannot be called directly from the report catalog there's no need to show them in the matrix (at least for my purpose right now...)

Does anybody know how to retrieve this report property from the repository?

Infor dEPM-Version is 12.10

Thanks,

Ralf

MikeLewis

Ralf,

I think this will do it.

(Replace ForecastEntry with your Report Name.)

SELECT
R.Name as ReportName,
S.Name as SettingName,
CR.Value
FROM coReport R
Join coCombRepSCL CR
ON R.IDReport=CR.IDCombReport
Join cSetting S
ON CR.IDSetting=S.IDSetting
Where R.Name='ForecastEntry'
And S.Name='Reporting_Report_HideInWS'

ReportName     SettingName                            Value
ForecastEntry    Reporting_Report_HideInWS    0

0712131256598360.doc