Overview

In this section, you will find information about how to create a report in SalesForce.

Concerned profiles:

ALL

Table of content

Step By Step

Creating a Report

•David wants to prepare a report so he goes to the tab Reports.

•David clicks on New Report.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:36:39.png

Selecting the Report Type

•David is transferred to the Create New Report page.

•Now he can choose from a number of Report Types

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:36:55.png

•As David wants to create an Opportunity report, he types “Opportunities” in the search box.

•He is presented with the search results: all reports with Opportunities in the title.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:38:57.png

•Then, he selects Opportunities from the search results list.

•David clicks on the Create button.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:39:30.png

Familiarizing with the Report page

•David has opened the page where he can start creating his new Report.

•The page consists of 3 parts: a panel to add fields, filters and the preview of the result

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:40:39.png

Adding fields to his Report

•First, David will clean all of the fields that he does not need. As he wants to make a Report on Closed Opportunities by Opportunity Owner he will only keep the Opportunity Name, Opportunity Owner, Account Name, Closed Date, Probability and the Stage.

•He drags and drops the fields from and to the Fields Panel to add or remove them.

In a report, you can select all the fields available for the record and report on it.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:40:51.png

•Another way of adding fields is by double-clicking on the fields.

•David searches for and double-clicks on the Expected Yearly Revenues field to add it automatically.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:41:3.png

Familiarizing with the filters

•Now that the report includes all the fields David wanted, he will refine the output by applying filters. He would like to get only the weeklies from the Happy Chocolate account.

•He goes to the filter zone and there he has some options to choose from.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:41:20.png

Defining Report filters

•David clicks on the Add button in the Filters section in order to add a filter.

•A new line appears.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:41:35.png

•David creates a filter to narrow the Opportunities Report down to the Closed ones.

•In the filter he selects Stage – equals – and clicks on the lookup field.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:41:44.png

•He selects all the stage that are Closed and clicks on Insert Selected.

•David now needs to click on OK.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:42:4.png

Previewing the Report

•Now, he is able to see the results in the preview section.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:42:18.png

Grouping the Report by field

•David wants to group the Report by Opportunity Owner.

•In order to do this, he clicks on the arrow next to the Opportunity Owner field and clicks on Group By This Field.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:42:29.png

•David can see the result in the Preview section.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:42:38.png

Saving the Report

•David sees that the report is correctly created.

•Now, he would like to save it in order to be able to re-run it later.

•He clicks on the Save button.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:43:0.png

•The Save Report window opens and David will enter a Report Name and select a folder to save the report in.

•It’s always recommended to save the report in the folder “My Personal Custom Reports” before saving it into another shared folder

You must ONLY save your report in the folder “My Personal

Custom Reports”

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:43:11.png

•David enters “Closed Opportunities by Owner” as the Report Name.

•He chooses where the report should be saved. He selects the Report Folder “My Personal Custom Reports”.

•Then he clicks Save.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:43:43.png

Exporting the Report to an excel file

•Now, David would like to export the report into an excel file

•He clicks on Run Report to run the report on the whole database (please note the preview is not always complete, it is limited to a number of lines).

•Then David clicks on the button Export Details.

Syensqo IS - Customer Support > Reporting in SFDC – Create reports in SFDC > image2016-8-8 16:43:56.png