Ascendix TechnologiesOpen/Close Panel

CRM Consulting Services and Commercial Real Estate Software Since 1996

Open Search
  • Services
    • CRM Consulting
    • Dynamics 365 Consulting
    • Salesforce Consulting
    • Salesforce Implementation Services
    • Salesforce AppExchange App Development
    • Salesforce Integration Services
    • Software Development Outsourcing
    • Ascendix CRM Concierge Service
  • Products
    • Ascendix Search
    • AscendixRE CRM
    • AscendixRE Pricing
    • AscendixRE Capital Markets
    • AscendixRE Land
    • Composer
    • MarketSpace
    • Property Listings Website
  • Industries
    • Financial Services
    • Commercial Real Estate
  • About
    • Our Team
    • Meet Our CEO
    • Engagement Models
    • How We Work
    • Ascendix Videos
  • Clients
  • Blog
  • Contact
  • Login

A Full Guide on How to Create Salesforce Reports

June 26, 2020

How to Create Reports in Salesforce

Salesforce offers you a powerful reporting tool that helps to understand your data. In this post, we’ll show how to create Salesforce reports, export them to Excel, subscribe to Salesforce reports, and place them to the dashboard.

Table of Contents

  • So, What is a Salesforce Report?
  • Salesforce Report Types
  • How to Create Reports in Salesforce: 6 Simple Steps Guide
  • How to Delete a Salesforce Report
  • How to Edit a Salesforce Report
  • How to Subscribe to a Salesforce Report
  • How to Export Salesforce Reports to Excel
  • How to Place a Salesforce Report on a Dashboard
  • Salesforce Reports Alternative?

So, What is a Salesforce Report?

The Salesforce report is a standard object that helps you to summarize data and see them in a meaningful fashion. Among the reasons why you may need Salesforce reports is when you need to export the data to Excel or to build the dashboards. Also, due to the Salesforce report, you can make a data analysis based on your client’s requirements.

You can find the various explanations on the Internet on how to create reports, but before you do it, pay attention to the Salesforce report types and formats, so you’ll understand clearly their peculiarities.

There are two different report types:

  • Salesforce standard report type is a predefined standard report type that cannot be customized. For example, “Accounts and Contacts” report type.

 

Standard Salesforce report types

Salesforce standard report type

 

  • Salesforce custom report type is added by an administrator and specified which objects and fields are included in the report. For example, the “Next Year Lease Expiration Report” report type.

 

Salesforce Custom Report

Salesforce standard report type

 

🤓Check tips and tricks from our experts on  how to fix Salesforce custom report types issues

 

Salesforce Report Types

A report format is a set of records and fields that meet the defined criteria.

There are four Salesforce report types: Tabular, Summary, Matrix, and Joined. The tabular report is the default format.

In Salesforce Lightning there’s now no longer a drop-down where you can choose the report type.

 

Salesforce Report Types

Salesforce Tabular Report

It is the simplest Salesforce report type, which presents data in rows and columns. If you want to show data without subtotals, calculations, or groupings, then this report suits you. Some of the examples to show are “All Open Opportunities”, or “Top 15 Opportunities by Revenue”.

Salesforce Summary Report

This is another Salesforce report type, which is similar to the Tabular. With this type of report, you can group rows of data, create charts, and calculate totals.

How to build Salesforce Summary Report

Summary report type in Salesforce Classic

Salesforce Matrix Report

It allows you to group records both by row and by column. Some of the examples to show are “Opportunities” grouped by “Stage” and “Close Date”.

How to build Salesforce matrix report

Matrix report type in Salesforce Classic

Salesforce Joined Report

This report allows you to create different views of data from multiple report types. For example, you want to show “Open Opportunities” and “Closed Opportunities” side-by-side to help you spot the differences.

Salesforce Joined Report in Classic

Joined report type in Salesforce Classic

How to Create Reports in Salesforce: 6 Simple Steps Guide

Our Salesforce Consultant Chris Petersen recorded a detailed video on how to create reports in Salesforce.

 

If you need to build a Salesforce report, you can do it easily by following the procedure described below.

How to build reports in Salesforce

Step 1. Create a New Salesforce Report

To find a Salesforce report, you need to look at your horizontal navigation bar for the “Reports” object.

If you don’t see this tab in the bar:

  • Look at the objects that are in the “More” tab;
  • Click “New Report”, and you’ll see this window.

 

How to choose the Salesforce report type

Choose the Salesforce report type

Step 2. Choose a Salesforce Report Type

Select the Salesforce report type and click on the “Continue” button. Note, that the list of reports is quite exhaustive and range from various types of “Accounts”, “Opportunities” to “Deals”, “Cases” etc. To simplify your search, you can start typing in some keywords. For example, if you want a report on your deals, you can click and type in “Deals”, and you will see the suitable results to that.

 

How to select Salesforce report type with keywords

Select a Salesforce report type with the help of keywords

Step 3. Filter Your Data

Filtration is one of the key features if you have big lists of data. To begin selecting the scope of the Salesforce report using the standard Salesforce report filter logic, click the “Filters” panel.

Let’s say, you might want to filter reports only on the open deals. To do that search you will need to:

  • Find the field which is called “Status”,
  • Click into “Status” filter type and select what statuses you want to show (e.g. only open deals status, won, lost ones or all),
  • Click “Apply”.

 

How to Salesforce filters pane

Use filters pane in  Salesforce report

 

If you want to add any other filters using Salesforce report filter logic, you can click on all these field names and decide what other fields you might want to report on.

 

Step 4. Click the Outline Pane to Show Columns/Fields

With the help of the “Outline” pane, you can add and remove columns with a simple drag and drop feature.

For example, the deal name is not likely to be sufficient in the report. Potentially, you want to add an estimated closed date, so you could just type “Est. Close Date” in the Columns section and it will filter your results. You can double click or click and drag the field over to the report on the right and to the respective location you need.

 

how to add columns on the Salesforce report

Add additional columns on the Salesforce report

Step 5. Group Your Data

If you want to do the estimated closed date as the grouping, you can type in the “Groups” section “Est. Close Date” and your results will be filtered again.

 

How to group data on Salesforce

Group your data on Salesforce report

 

In the case of grouping “Deals” by “Est. Close Date” you can also group the date by Day, Calendar Week, Calendar Month, etc.

 

how to group data by date in the Salesforce report

Group your data by date in the Salesforce report 

Step 6. Save Your Salesforce Report

To save your Salesforce report, you will need to:

  • Click “Save & Run”,
  • Complete the “Save Report” details by entering a “Report Name”, “Report Unique Name”, and “Report Description”.
  • Select a Folder to save your report in. Note, that if you need to make it visible only to you, you need to choose “Private Reports Folder”. But if it should be visible for your organization, select “Public Reports Folder”.
  • Click “Save”.

 

How to save the Salesforce report

Save your Salesforce report

 

*Note that the steps for creating Salesforce reports in Salesforce Classic may differ from above-mentioned ones. Find out more here.

 

How to Delete a Salesforce Report

There are two main methods on how to delete a report:

  1. To delete from the Reports tab,
  2. To delete from the report’s run page

To delete the Salesforce report from the Reports tab you need to go to the “Reports” at the Navigation Bar. Then click the Arrow Down button next to the report you want to delete and choose “Delete”.

To delete the report from the report’s run page, click the “Arrow down button” and choose “Delete”.

 

Salesforce consulting services

How to Edit a Salesforce Report

To edit click the Arrow Down button and choose “Edit”.

 

How to Subscribe to a Salesforce Report

If you want to receive report notifications to keep you updated, you can turn on the subscribe feature.

 

How to Subscribe to a Salesforce Report

Step 1. Go to the Reports Tab

Click on the “Reports” at the Navigation Bar.

Step 2. Click the Arrow Down Button and Choose “Subscribe”

Next to the report, you want to subscribe to, click the “Arrow Down” button and choose “Subscribe”.

Step 3. Edit a Subscription

Schedule how often (every weekday, daily, or weekly) and at what time to evaluate your subscription. For example, run the report every week on Friday at 7 p.m.

 

How to edit Salesforce report subscription

Edit the subscription to the Salesforce report 

 

Please, note that you can add conditions at this step by specifying each condition in three parts:

  • Aggregate – is a basis of the condition (e.g. sum of amount, largest amount).
  • Operator – is a basis of comparison (e.g. equal, greater than, etc.).
  • Value – is the number that you want the aggregate compared to (e.g. 2000).

 

How to specify the conditions on the Salesforce report subscription

Specify the conditions on the Salesforce report subscription

Step 4. Save your Subscription

Click on “Save”. Make sure the subscription is active if you’re ready to start receiving notifications.

 

How to check if the subscription to the Salesforce report is active

Check if the Salesforce report subscription is active

 

If you wonder how to unsubscribe from a report in Salesforce, here are simple steps for Salesforce Lightning and Salesforce Classic:

  • If you are in Lightning, click on “Subscribe” and then click on “Unsubscribe” on the next page.
  • If you are in Classic, click on “Edit Subscription” and then click on “Delete” on the next page.

To find out which are the subscribed reports, you can select the drop-down from the list view, called “Items I am Subscribed to”.

How to Export Salesforce Reports to Excel

Follow these 3 Steps to export your report to Excel.

How to Export Salesforce Reports to Excel

Step 1. Choose the Report to Export

To select the Salesforce report to export:

  • Click on the “Reports” at the Navigation Bar,
  • Click the “Arrow Down” button next to the report you want to export,
  • Choose “Export”.

 

How to choose the Salesforce report to export

Choose the Salesforce report to export

Step 2. Choose an Export View

If you choose Formatted Report, Salesforce exports it with the report header, groupings, and filter details. In this case, the export file type is .xlsx.

The Details Only Report exports each detail row without formatting. You can set the Format to Excel Format .xls or Comma Delimited .csv.

 

How to choose an export view on the Salesforce report

Choose an Export View on the Salesforce report

 

Step 3. Export your Report

Click on the “Export Button”.

 

👉 Learn more on how to export data from Salesforce to Excel.

 

How to Place a Salesforce Report on a Dashboard

If you want to take a Salesforce report and put it on a dashboard you should follow the next steps.

How to Place a Salesforce Report on a Dashboard

Step 1. Edit a Dashboard

Go to the dashboards tab, pick a dashboard, and click on “Edit”.

Step 2. Click on Add Plus Component

A list of the available reports will be shown to you. Select the report which you would like to add.

 

How to add the Salesforce report on the dashboard

Add the Salesforce report on the Dashboard

Step 3. Choose a Report Type

Choose how the report will be shown to you:

  • as a bar graph,
  • as a chart,
  • as a funnel.

 

How to choose how the Salesforce report will be displayed

Choosing how the Salesforce report will be displayed

 

At this step you can customize your Dashboard Component:

  • Y-Axis and X-Axis – сhoose a group or a measure to display on each axis,
  • Display Units – choose how the values will be displayed,
  • Show Values – specify if the chart segments will display values, or not,
  • Show Chatter Photos – choose if the chatter photos will be displayed or not,
  • Y-Axis Range or X-Axis – set the axis range,
  • Decimal Places – choose how many decimal places should be on numbers,
  • Sort By – choose how to sort groups or measures displayed in the bar chart,
  • Sort By – if applicable, choose how to sort second-level groups or measures displayed in the bar chart,
  • Custom Link – link from a dashboard component to a Salesforce Record or another website,
  • Max Values Displayed – specify how many groups display in the bar chart,
  • Title – give the chart a title,
  • Subtitle – give the chart a subtitle,
  • Footer – give the chart a footer,
  • Component Theme – choose a Light or a Dark theme.

Please note that you can Customize chart colors from the dashboard properties menu:

  • Go to the “Dashboard”,
  • Click on “Edit”,
  • Open the Properties menu by clicking the “Gear Icon”,

 

How to open properties menu on the Salesforce report

Open properties menu on the Salesforce report

 

  • Customize colors in your dashboard by choosing a light or dark theme and one of 14 color palettes.

 

How to customize colors in the Salesforce dashboard

Customize colors in the Salesforce dashboard

 

Step 4. Add Your Report on the Dashboard

Click on “Add”. It essentially adds itself to the dashboard, but you can drag and drop that component up. If you need it to go to the very top you just continue to do that to replace the widgets and save.

Salesforce Reports Alternative?

Salesforce reports are an advanced feature and they offer you much more functionality to search for your data in comparison to Salesforce Global Search and List views.

But what if you want to be able to build even more complex search requests, use maps to narrow your results, or simply being able to mass edit your records? We built Ascendix Search app to upgrade your Salesforce experience and let you easily build granular lists of prospects to call, mass email, or stay in touch.

Do you still have questions about Salesforce custom report types or need help with your Salesforce org? Our Salesforce consultants are happy to help! Get in touch with us.

Salesforce CRM consulting services

Recommended For You:

  • How to Implement Salesforce: The Definitive…
  • What is Salesforce? Expert Insight on What…
  • Salesforce Benefits & CRM Perks Guide: How to Get…

Blog CRM Consulting Salesforce

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

About us

  • About Ascendix
  • Our Services
  • Case Studies & Reviews
  • Ascendix Videos

Products

  • Ascendix Search
  • AscendixRE CRM
  • AscendixRE Capital Markets
  • AscendixRE Land
  • Composer
  • Commercial Property Listings Website

Contact Us

  •   +1 888-346-3276 Ext 2
  •   +1 972-889-8090
  •   Contact Sales
  •   Request Support
  •   Ascendix Corporate Office
    12222 Merit Drive Suite 1760
    Dallas, Texas 75251
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

© 2021 Ascendix Technologies. All Rights Reserved | Privacy Policy Sitemap

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Read MoreCookie settings
REJECTACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience. Read our privacy policy.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

CookieTypeDurationDescription
__cfduid11 monthThe cookie is set by CloudFare. The cookie is used to identify individual clients behind a shared IP address and apply security settings on a per-client basis. It does not correspond to any user ID in the web application and does not store any personally identifiable information.
cookielawinfo-checkbox-advertisement01 yearThis cookie is set by GDPR Cookie Consent plugin. The purpose of this cookie is to check whether or not the user has given their consent to the usage of cookies under the category 'Advertisement'.
cookielawinfo-checkbox-analytics01 yearThis cookie is set by GDPR Cookie Consent plugin. The purpose of this cookie is to check whether or not the user has given the consent to the usage of cookies under the category 'Analytics'.
cookielawinfo-checkbox-necessarypersistent11 monthsThis cookie is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-non-necessarypersistent11 monthsWe use this cookie to store the user consent for the cookies in the category "Non Necessary".
csrftoken011 monthsThis cookie is associated with Django web development platform for python. Used to help protect the website against Cross-Site Request Forgery attacks
iopersistentSessionThis cookie is set by HeyOliver and it preserves user session state across page requests.
pctrk01 yearUsed to count page views by unauthenticated users against license usage.
PHPSESSIDpersistent1 yearThis cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user session on the website. The cookie is a session cookies and is deleted when all the browser windows are closed.
viewed_cookie_policypersistent11 monthsThe cookie is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Analytics

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.

CookieTypeDurationDescription
__utma02 yearsThis cookie is set by Google Analytics and is used to distinguish users and sessions. The cookie is created when the JavaScript library executes and there are no existing __utma cookies. The cookie is updated every time data is sent to Google Analytics.
__utmb030 minutesThe cookie is set by Google Analytics. The cookie is used to determine new sessions/visits. The cookie is created when the JavaScript library executes and there are no existing __utma cookies. The cookie is updated every time data is sent to Google Analytics.
__utmc0The cookie is set by Google Analytics and is deleted when the user closes the browser. The cookie is not used by ga.js. The cookie is used to enable interoperability with urchin.js which is an older version of Google analytics and used in conjunction with the __utmb cookie to determine new sessions/visits.
__utmt010 minutesThe cookie is set by Google Analytics and is used to throttle the request rate.
__utmz06 monthsThis cookie is set by Google analytics and is used to store the traffic source or campaign through which the visitor reached your site.
_gapersistent2 yearsThis cookie is installed by Google Analytics. It registers a unique ID that is used to generate statistical data on how the visitor uses the website.
_gat_gtag_UA_76342539_1persistent1 minuteGoogle uses this cookie to distinguish users.
_gat_UA-76342539-1persistent1 minuteThis is a pattern type cookie set by Google Analytics, where the pattern element on the name contains the unique identity number of the account or website it relates to. It appears to be a variation of the _gat cookie which is used to limit the amount of data recorded by Google on high traffic volume websites.
_gidpersistent1 dayThis cookie is installed by Google Analytics. The cookie is used to store information of how visitors use a website and helps in creating an analytics report of how the wbsite is doing. The data collected including the number visitors, the source where they have come from, and the pages viisted in an anonymous form.
_uv_id02 yearsThe cookie is set by Slideshare.net. It collects data on the user's visits to the website, such as which pages have been read.
bcookiepersistent2 yearsThis cookie is set by linkedIn. The purpose of the cookie is to enable LinkedIn functionalities on the page.
browser_idpersistent1 yearA unique indentifier for the web browser
bscookie12 yearsUsed by the social networking service, LinkedIn, for tracking the use of embedded services.
cusidpersistent30 minutesThis cookie is set by Clickdimensions and is used to establish and continue a user session with the site. When a user views a page on the site, the script code attempts to update this cookie. If it does not find the cookie, a new one is written and a new session is established. Each time a user visits a different page on the site, this cookie is updated to expire in 30 minutes, thus continuing a single session for as long as user activity continues within 30-minute intervals. This cookie expires when a user pauses on a page on the site for longer than 30 minutes.
cuvid02 yearsThe cookie is set by ClickDimensions. This cookie is typically written to the browser upon the first visit to the site from that web browser. If the cookie has been deleted by the browser operator, and the browser subsequently visits the site, a new __cuid cookie is written with a different visitor unique ID. This cookie is used to determine unique visitors to the site and it is updated with each page view. Additionally, this cookie is provided with a unique ID that the application uses to ensure both the validity and accessibility of the cookie as an extra security measure.
cuvonpersistent30 minutesThis cookie is set by Clikdimensions and is used to signal the last time a visitor viewed a page. It expires in 30 minutes from set/update.  
GPS030 minutesThis cookie is set by Youtube and registers a unique ID for tracking users based on their geographical location
heyo_pPersistentRegisters a unique ID that is used to generate statistical data on how the visitor uses the website.
heyo_ssessionRegisters a unique ID that is used to generate statistical data on how the visitor uses the website.
ho_*-active_quickview_tabPersistentKeeps the current state of the web app and is set by HeyOliver.
ho_*-heyoliver_referrersessionThis cookie is set by HeyOliver and collects information of the user's referrer.
ig_did19 yearsThis cookie is set by Instagram.
li_sugrpersistent2 monthsLinkedIn Insight Tag, when IP address is not in a Designated Country
lisscpersistent1 yearUsed by the social networking service, LinkedIn, for tracking the use of embedded services.
UIDR01 yearThis cookie is set bu scorecardresearch.com. The cookie is used to tracks the users activity across the internet on the browser such as visit timestamp, IP address, and most recently visited webpages. and may the data send to 3rd party for analysis and reporting to help their clients better understand user preferences.
vuid02 yearsThese cookies are used by the Vimeo video player on websites.
YSC1This cookies is set by Youtube and is used to track the views of embedded videos.
Advertisement

Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.

CookieTypeDurationDescription
_fbppersistent2 monthsThis cookie is set by Facebook to deliver advertisement when they are on Facebook or a digital platform powered by Facebook advertising after visiting this website.
fr12 monthsThe cookie is set by Facebook to show relevant advertisments to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook pixel or Facebook social plugin.
IDE12 yearsUsed by Google DoubleClick and stores information about how the user uses the website and any other advertisement before visiting the website. This is used to present users with ads that are relevant to them according to the user profile.
uid01 yearThis cookie is used to measure the number and behavior of the visitors to the website anonymously. The data includes the number of visits, average duration of the visit on the website, pages visited, etc. for the purpose of better understanding user preferences for targeted advertisments.
UserMatchHistorypersistent1 monthThis cookie is set by Linkedin and is used to track visitors so that more relevant ads can be presented based on the visitor's preferences.
VISITOR_INFO1_LIVE15 monthsThis cookie is set by Youtube. Used to track the information of the embedded YouTube videos on a website.
Functional

Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.

CookieTypeDurationDescription
langpersistent1 yearThis cookie is used to store the language preferences of a user to serve up content in that stored language the next time user visit the website.
lidcpersistent1 dayThis cookie is set by LinkedIn and used for routing.
mid09 yearsThe cookie is set by Instagram. The cookie is used to distinguish users and to show relevant content, for better user experience and security.
test_cookiepersistent11 monthsThis cookie is set by doubleclick.net. The purpose of the cookie is to determine if the users' browser supports cookies.
upersistent2 months
Save & Accept