+ Start a Discussion
Teach_me_howTeach_me_how 

INQUIRY: Report Type Clean-Up

We are planning to do a clean-up of our report types and are looking for any recommendations/best practices around this. Could you help us with the following questions:

We noticed that when you create a new look up field, a new standard report type is created automatically. Is there a way to turn this feature off?
Is there a way to get a complete list of standard report types available in our org?
What is the best way to get a list of used and unused report types?
What is the most effective way of hiding unused report types?
How can we easily get a list of duplicate report types (Meaning same object/order is used )?
If there are duplicate report types, how can we tell if there are difference in terms of available columns/fields?
Anil KamisettyAnil Kamisetty
Hi

If the Reporting is enabled on an object, Salesforce creates Report Types for that object. It can't be turned off. Only way is "Don't enable the Reporting feature on the Object level".

While creating a new report, one can see the list of available Report Type by expanding various options in there. If you need the list of custom report types, go to Setup --> Administer --> Create --> Report Types.

If the User has access on the Object and to create Reports, user will see the report types on the corresponding object. Probably disable the Report creation privilege and that should do it.

It may not be so easy to find what report types are for what objects, people can name in their own way. Thorough examiniation is required to find out what report type is on what object and whether it is used or not.

If you have created two custom report types on the same object, you can edit the corresponding Report Type --> Field Layout and see the list of columns exposed in that report type.

Note : If this answers your question, please mark this as Answered, thus helping others.