Custom reports
Custom Report types allow you to build a framework in the Report wizard. Here, users can create and customize reports. You build custom report types between objects so that you can:
- Choose which standard and custom objects to display to users who are creating and customizing reports
- Define the relationships between objects displayed to users who are creating and customizing reports
- Select which objects' fields can be used as columns in Reports.
The visibility of Custom Report types in the Report wizard is controlled by users access to the objects in the report type.
Creating custom reports
Following are the steps to create a Custom Report:
Log in to your Salesforce account.
Click Setup > Setup > Feature Settings > Analytics > Reports & Dashboards > Report Types.
This displays the Custom Report Types page as shown in the following image:
Click Continue.
The following All Custom Report Types page is displayed:
Click New Custom Report Type.
The following page gets displayed:
Select the required Primary Object.
Enter the Report Type Label.
Enter the Report Type Name.
Enter the Description.
Enter the Store in Category.
Select the Deployment Status.
A report type with Deployed status is available for use in the Report wizard. While in Development, Report types are visible only to authorized administrators and their delegates.Click Next.
This displays the details on your screen as shown in the following custom report type page:
Click Save.
This displays the following screen:
Go to Reports > New Report.
This displays the following Choose Report Type page:
Click Continue.
This displays the details as shown in the following image:
Note:Your Report type has three panels, namely Fields, Filter, Preview as shown in the preceding image.
You can double click on any of the fields in the Fields panel or Drag and drop the required field from the Fields panel under the Preview panel to generate the Report as per your requirements.
Click Run.
This generates a report as shown in the following image:
Note:You can click Edit, if you want to make any further changes to your Report.
Click the drop-down arrow and select Save.
Enter the Report Name.
Enter the Report Description.
Enter the Report Unique Name.
Note:When you enter the Report Unique Name, ensure that it begins with a letter and use only alphanumeric characters (A to Z and 0 to 9)Also, this name cannot end with an underscore or two consecutive underscores.
For example,
d395j _ _ (Incorrect)
d395 _ _ j (Incorrect)
d39_5j (Correct)
Select the required Report Folder.
If you want to keep your Report confidential, for any given reason- Select My Personal Custom Reports folder.
Click Save.
You have successfully created your Custom Report.