Lightning Report Builder a new way of managing reports and dashboards

Lightning Report Builder a new way of managing reports and dashboards

Salesforce Lightning is a modern and personalized user interface that provides users a more user-friendly experience for working on Salesforce CRM. The Lightning experience has everything for its users to keep on going. 

Salesforce Lightning Experience ensures that the data is available to salespeople, wherever they are. Data and information are customized in the form of reports and visualized as dashboards that help in getting deeper insights, make the right decisions, and take proper actions.

This post will give you an in-depth understanding of the Report Builder in Salesforce Lightning. But, before discussing on Report Builder, let us first explore the basics of reports and dashboards quickly. 


The Report in Salesforce is required to access the data. It is a list of records that are displayed in rows and columns. The Report will help you track your progress in various fields. It is used to understand, analyze, organize the data and forecast the different methods that are required to occur in the Sales process. 

Reports are stored in a folder that can be public, hidden, or shared and allowed to be set to read-only or read/write format. However, Lightning experience doesn’t support all the Salesforce standard objects but it supports Report Builder. Users can create, customize, and view reports for all the standard objects.

To put it simply, you can create a report to show opportunity, activity, and any other related data for your accounts in Salesforce. Creating and maintaining reports is easier by implementing the right approaches and methods.



In today’s data-driven environment, Dashboards generate a lot of buzz in businesses. Dashboards are an effective way of visualization of data. With this Salesforce Lightning component, you can view your existing reports in a wide variety of forms such as charts, tables, and graphs. Basically, it is a single screen loaded with important data and information that gives users a unified and at a glance, view of the data that matters to their organization process. It allows you to view multiple reports like charts, graphs, and tables side-by-side.

Both Reports and Dashboard become real-time smart utilities to allow users’ make better decisions.


Moving on from this brief introduction, let’s deep dive into enabling Report builder in Salesforce Lightning.

Overview of Report Builder

It is a visual drag-and-drop feature that can be used to create and edit reports. This is the platform where it is required to choose the report type, format, and field to build up a complete report. To launch the Report Builder, you just need to click on New Report.

Features of Lightning Report Builder:

  • Build and modify reports easily and quickly
  • Organize systematically with folders and subfolders
  • Flexible alteration to reports format with row and column fields
  • Execute without saving
  • Merge dashboard components directly into the reports

Steps to enable Salesforce lightning report builder

Step 1: Open “Reports and Dashboards settings”

Setup>  Quick Find Home textbox type “report” >  Select Reports and Dashboard settings.

Step 2: Allow permission through the profile

Setup > Quick find box search > users profiles > system administrator.

Step 3: Allow permission using the permission set

To open permission set- Setup  > Quick find box search  > users permission set.

Step 4: Click on the Report builder checkbox for Lightning Experience.

Finally, now you can see multiple actions to create new reports quickly and efficiently.

Comparison between Salesforce Classic and Lightning Reports Builder




Report Format

Choose a report format before grouping data

A report format is updated automatically  

as you group data

The enhanced and creative formatted report

Export a report in the printable view

Formatted export option to print all filters, data, column headers

Summary, tabular and matrix reports

Grouping data is a difficult task

Grouping data is an easy task

Lightning Dashboard

Add and display 3 reports in a row

Add and display 12 reports in one row

Report Formula Editor

Have the scroll down option

Doesn’t have the scroll down option

To summarize, here are the advantages of lightning report builder compared to the Classic lightning builder:

  1. Add reports to dashboards easily and effectively.
  2. Add more than 12 reports in one column or row.
  3. Simple Report formula builder.


With the most exciting Beta release of Salesforce i.e. Lightning Report Builder, below are the highlights on some features that haven’t moved over from classic yet in lightning experience, but they will be on time.

The huge omissions include Cross Filters and Bucketing. Salesforce has been working hard and smart to make improvements and adding new features. Salesforce is working actively to improve the light report builder with every release.


Lightning Experience is the best and excellent user interface created by Salesforce. Some of the key features are the clear reason to switch from classic to Lightning Experience such as sharing your calendar, Report folder sharing, interactive forecasts, Lightning Report Builder.

The new lightning report builder provides a new, modern look and feels to the Salesforce users. Salesforce has been introducing new functionalities and enhancements with every release.  

Really a good job, Salesforce!

Regardless of the current limitations, I am looking forward to more exciting features in upcoming releases.

Want to talk about Salesforce Lightning Report Builder? Feel free to post your comments below in the comment section for any questions related to the post or contact me at

Leave a Reply