Salesforce

How to create a report in SalesForce?

Report creation in SalesForce

Creating a report in SalesForce is a basic and very important operation, as is it also the base to export data from SalesForce to Excel or CSV for example.

Creating a report can be done by access the report menu in the navigation bar, and must be added in the bar if not existing yet.

Once a report has been created, it is possible to export the SalesForce report to Excel using the report export function.

1 – Create new SalesForce report

Start by opening the reports option menu in the navigation bar to access the report screen. In case the reports menu is not available in the navigation bar, try clicking on more option to show hidden menu items, or add the reports menu to the navigation bar if it is not there.

How to create a report in SalesForce? : Reports menu in navigation bar
How to create a report in SalesForce? : Reports menu in navigation bar

Then, click on the new report button which is situated on the upper menu of the reports list – the list might be empy, depending on your reports selection criteria.

There is also from there a button to create a button in SalesForce classic, in case you need to do that.

How to create a report in SalesForce? : New report button
How to create a report in SalesForce? : New report button

Select the report type in all the report types that are available: accounts and contacts, opportunities, customer support reports, opportunities with products, opportunities with contact roles, and many more.

How to create a report in SalesForce? : Creation of an opportunities with products report
How to create a report in SalesForce? : Creation of an opportunities with products report

After having selected the type of report that you want to create, click on the button continue in ordre to proceed with the SalesForce Lightning report creation.

How to create a report in SalesForce? : Continue creation of the SalesForce Lightning report
How to create a report in SalesForce? : Continue creation of the SalesForce Lightning report

2 – Customize SalesForce report

It is now necessary to customize the report, as only a standard report has been created in SalesForce Lightning by default.

There are many ways to customize it: add or remove columns, filter on data, order the data by a specific column, and more.

The options to customize the report are available on the left hand side.

How to create a report in SalesForce? : Standard SalesForce report created
How to create a report in SalesForce? : Standard SalesForce report created

For example, by dragging and dropping a column name from the outline fields on the left hand side of the screen to the report in the main part of the screen, that column will be added to the report.

Click on the cross next to the column name to remove it.

How to create a report in SalesForce? : Drag and drop a column name to add it to the report
How to create a report in SalesForce? : Drag and drop a column name to add it to the report

By clicking on the arrow next to the column header name, more options will be available.

Selecting the sord ascending option will sort the whole report on the current column by ascending value, from lower to highest.

The sort descending option will do the inverse, all report lines will be sorted based on that column from the highest value to the lowest.

Grouping rows by this field option will group all rows in the report that have a similar value in that column – the equivalent in Excel of a merge cells.

There are also options to move the column to the left or the right, in order to customize the SalesForce Lightning report as it is best for you.

Finally, an option to remove the column exist, in which case it will not be lost: it will simply be removed from the SalesForce report, but can be added back anytime by dragging and dropping the column name from the left hand side menu.

How to create a report in SalesForce? : Report columns customization options
How to create a report in SalesForce? : Report columns customization options

Finally, it is possible to change the report name by clicking on the pencil next to the report name, right below the navigation bar on the left side.

Type the report name that best fits the report’s description to be able to retrieve it easier later on, and to make it clearer to your coworkers.

How to create a report in SalesForce? : Changing report name
How to create a report in SalesForce? : Changing report name

3 – Save SalesForce report

After the SalesForce Lightning report has been created and customized, do not forget to save it by using the upper menu Save option, below the navigation bar and on the right side of the screen.

There is also another option to run the report without saving it, in case you do not want to access it later but simply want to test it or to access the data quickly.

However, the most common option would be to save and run, which will save the report in the list of accessible reports, and show the reports results on screen.

How to create a report in SalesForce? : Save and run option to save report
How to create a report in SalesForce? : Save and run option to save report

The saving form will ask again to confirm the report’s name, as it is a last opportunity to modify it.

Additionally, a unique report name will be requested. This unique report name must not already exist in the system, even if created by another user and on which you have no access. This will be the unique report handler code, and must be unique.

Before saving, enter a longer description if necessary, especially in case the report serves a very specific business case, such as end of month customer report for example, so your coworkers can identify quicker its usage.

How to create a report in SalesForce? : Saving new report
How to create a report in SalesForce? : Saving new report

4 – Export SalesForce report

Once the report has been saved, after having clicked on the save and run button, the report data will be displayed on screen, along with a message stating that the report has been saved.

This pop-up will disappear after a few seconds by itself.

An edit menu now appears on top of the SalesForce Lightning report on the right side of the screen, and offers extra option.

How to create a report in SalesForce? : Report successfuly saved
How to create a report in SalesForce? : Report successfuly saved

By clicking on the arrow next to the edit menu, extra options will be available.

The edit in SalesForce Classic option will open the report for edition in SalesForce CLassic interface.

The save as option will save the report with an other name, thus creating a copy.

The save option will save the report changes that have been done in the edition mode.

The subscription option will allow you to get notified whenever the report changes.

The delete option will allow to delete the report from the database, however, before doing so, make sure that nobody else needs that report.

The add to dashboard option will simply add that report to your personal user dashboard.

And finally, the most important option, the SalesForce Lightning export data option is available, which will allow to export the data through Excel or other means from the report.

See our detailed guide on how to export data from SalesForce to Excel for more details.

How to export data from SalesForce to Excel

How to create a report in SalesForce? : Reports edition and export options.
How to create a report in SalesForce? : Reports edition and export options.

Creating a report in SalesForce

The creation of a report in SalesForce is a pretty easy operation, given that you have access to the navigation reports menu.

Let us know in comments if you managed to create a report, and do not hesitate to ask in case you faced any issue during the SalesForce Lightning report creation or data export!