Reply
Contributor
World Tech
Posts: 7

Report on what reports a field is tied to.

We need to make a change to a heavily used field in our Salesforce org.  We are projecting that 100's of reports will not work when we make this change.  Is there a way to run a report that lists all reports that are tied to a specific field?  We need to repair the reports after the change is made before the end of the week and are trying to estimate the effort needed, but that is difficult without a solid list of which reports are effected. Please advise if you have any ideas.

 

Thanks! 

Regular Contributor
ron_reed
Posts: 38

Re: Report on what reports a field is tied to.

If you know how to use Eclipse, you can download all of the report metadata including field information.  Each report will be in a separate file in XML format.  You can then simply write a script (i find a vbscript to be easiest) to loop through all of the folders and files to search for the string - <field>YOURFIELDNAME</field> and increment a counter for each file found.