Report of all fields displayed on all reports

[amarks]

Hi folks,

I'm hoping some smart person here can help me. We're trying to reduce the custom fields and moving closer to OOB. The reporting in our instance has not been managed, and so we need a way to report on which reports contain custom fields.

We are already able to use the filter column to report on all reports that are filtered on a custom field.

How can we generate a report of all the reports and the 'columns' or fields they are displaying?

Thanks,

Adam

[Tony Chatfield1 · Accepted solution]

Hi, you should be able to report on the sys_report table
although you will need to manipulate the results outside of SNC (IE Excel or similar) as fields like 'field_list' AKA 'Select fields for list', are comma separated lists of fields. You might also need to include other fields like filter and group by, to ensure that you have all bases covered.