Pages

Friday, October 4, 2013

Salesforce: Default Fields in report

When create a new report in Salesforce, Salesforce will automatically put some fields into new report. We cannot customize the default fields when report created.

However, for custom report type, system administrator able to customize it. Here we go:

1. Create New Report Type
  • Setup - Create - Report Types
  • Select Primary Object, enter Label, Description, Category and select Deployment status
  • If you need to relate to other object, select from "click to relate another object"
  • Save



2. Edit Fields for Reports
From "Fields Available for Reports" section, click "Edit Layout" button.
  • Drag and drop fields from available fields (in right panel) to left layout to add field to be available in report builder, or drag and drop fields from page layout to right panel to remove it.
  • You can add lookup field by click link "Add fields related via lookup »", example: you are in Opportunity object, and want to add Account Address field
  • You can "Create New Section" in page layout, section created will be shown in different tree in the report builder
  • Click Edit Properties button to make the field show by default when user create new report in report builder, but before that you have to select fields (you can select multiple fields by hold Ctrl button). A window will be popup and you may change the field name will be Display As other label in report builder.
  • You can drag and drop section row up and down (if you have more than 1 section), this will effect to field tree position in report builder.
  • Save


Compare to the screenshot below for the layout in report builder:

Read here for more information.