Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top

Overview


Excerpt

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

Image Removed


 

 

Concerned profiles:

     ALL

Table of content


Table of Contents
indent30px
excludeOverview|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.
Image Added

Selecting the Report Type

•David is transferred to the Create New Report page.

Now he can choose from a number of Report Types







 

Image Added

 

 

•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.
Image Added
•Then, he selects Opportunities from the search results list.
•David clicks on the Create button.
Image Added

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

 Image Added

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.

 

Tip

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

 Image Added

•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.
Image Added

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. 

 Image Added

Defining Report filters

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

 Image Added

 

 

•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.
Image Added
•He selects all the stage that are Closed and clicks on Insert Selected.

•David now needs to click on OK.
Image Added

Previewing the Report

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

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.






 

Image Added

•David can see the result in the Preview section.Image Added

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.

 Image Added

 

•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

 

Note

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

Custom Reports” 

Image Added
•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. 
Image Added

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.

 Image Added

•He is transferred to a new window called Export Report.
•He clicks on the Export button. 
Image Added

Viewing the Report in the excel file

•He now has an excel file with all the data available from Salesforce.
 Image Added

Exporting the Report to an excel file

•David can also get a printable view of his report. For this, he clicks on Run Report to run the report on the whole database.
•Then David clicks on the button Printable View.
 Image Added

Viewing the Report in the excel file

•The result is a more presentable table to print or show, but less easy to work with in Excel.
 Image Added

Subscribing to a report

•David wants to receive automatically the report by email. To achieve this, he clicks on Subscribe.
 Image Added
Image Added

Wanting to schedule a report

•David wants to receive automatically the report by email. To achieve this, he clicks on Subscribe.
 Image Added

Scheduling the sending of the report

Image Added

Back to the top