As a Salesforce Admin, I find myself repeating many of the same tasks when I move to a new company and am in a new (new to me, anyway) Salesforce org. One of the projects that seems to crop up everywhere I go is report and dashboard cleanup. (I know, right? It’s so tempting to take the “Create Report Folders” and “Manage Reports in Public Folders” permissions away from everyone. Someday… but I digress.)
The first time I began a major cleanup of reports, dashboards, and their folders, I thought with absolute confidence, “This should be easy, I can just run a report on reports!”
Followed immediately by, “Uh, wait… is this all of the info I can get?” Right. In the standard “Reports” report type, that is all the info you can get.
Sound familiar? Allow me to introduce you to two of my favorite custom report types. These report types answer the two questions that are most important to me every time I start a report and/or dashboard cleanup.
Why: If you are thinking about turning on enhanced folder sharing, one of the most important things to know when determining levels of access is who created each folder.
How: Go to Setup | Create | Report Types and click “New Custom Report Type.” Select “Reports” as the Primary Object. Give your report type a name and description, and select Deployed so that you can start using it right away.
Then click Next, and you will see this nifty little Venn diagram. We do not need to add additional objects to this report, so this is fine the way it is.
Go ahead and click Save. After it is saved, scroll down to the “Fields Available for Reports” section and click “Edit Layout.” On the right-hand side of the edit page, in a box containing the available fields, click “Add fields related via lookup.”
A box will pop up with some lookup options. Click on “Folder” and there they are! All of the folder fields that we didn’t have before!
Select all of them, and click OK. Then click Save. (Optionally, you can create a new section before you save, if you want to keep the folder data separate from the report data.)
Why: Ever try to delete a report that you know is out of date or not useful anymore, and you get that error message – “Report cannot be deleted – one or more dashboards depend on this report” – but it doesn’t tell you which dashboard? Yeah, that.
How: Go to Setup | Create | Report Types and click “New Custom Report Type.” This time, select “Dashboards” as the Primary Object.
Click Next, and this time, you will want to add a related object – Dashboard Components.
Save, then scroll down and click “Edit Layout.” This time, select “Dashboard Components Fields” from the dropdown menu in the fields box, and then click “Add fields related via lookup.”
In the box that pops up, click on “Custom Report,” select the report fields that you want to include, and click OK. Then Save.
And just like that… two new report types that will quickly tell you all you need to know about your reports and dashboards. So what are you waiting for? Happy cleaning!
I’ve been doing Salesforce admin for about a year, with very little training in anything but the basics. I am looking for a way to analyze all reports that use certain custom fields (and even certain values in a custom field). My searches have not be very fruitful at this point; could you help point me in the right direction?
Hi Amy! You are not alone: https://success.salesforce.com/answers?id=90630000000CuGOAA0
I always use the Force.com IDE to search for fields in reports. It can be a pain because installing Eclipse is not always easy.
Steps:
1. Install Eclipse – https://wiki.eclipse.org/Eclipse/Installation
2. Install Force.com IDE – Make sure that reports are included in the things that you sync from Salesforce! – https://developer.salesforce.com/page/Force.com_IDE_Installation
3. Search for field – follow this video, except search the Reports folder instead of Classes – https://www.youtube.com/watch?v=W43RpGSk4jI
Sorry there is not an easier, more admin-friendly way! Maybe try the app referenced in my first link.
Hi!
As a relatively new salesforce admin trying to clean up an inherited org, these reports look perfect for cleaning up the cluttered report folders!
I managed to create the first report okay, but when I was setting up the Which Dashboards Depend On My Reports? report, when I got to ‘add fields via lookup’ I only had three options – Created By, Dashboard and Last Modified By, the Custom Report option wasn’t there at all?
Any help you could offer would be greatly appreciated!
Is your Primary Object “Dashboards”? If you use Reports as the Primary Object for this one, you can relate to Dashboard Components but not get that lookup option. Make sure you have Dashboards as the Primary Object and the Dashboard Components as the related record.