Friday, 6 January 2012

Salesforce.com Reports Explained


There are 3 kinds of reports in salesforce.com
1) Tabular Reports
2) Summary Reports
3) Matrix Reports
Each Report has a specific use and I am listing down the scenario's in which each type of Reports will be used:-
Tabular Reports: - These kinds of reports are used when the requirement is just to view the data.
Some of the examples are:-
  • Show me all Open Opportunities
  • Show me List of all Accounts which do not have any closed opportunity
  • Show me top 10 Opportunities by revenue
Dashboards cannot be created on Tabular Reports: - Salesforce.com ADM 201 certification question
Summary Reports: - These reports are used when the requirement is to summarize only X Axis. In short if you need to do the sum or calculate the average on even one parameter then summary report is the answer.
Some of the examples are:-
  • Show sum of all Open Opportunities
  • Show opportunities subtotal by my Team
Matrix Reports: - These reports are used when the requirement is to summarize both the Axis i.e. when requirement is to group both Rows as well as Columns.
Some of the examples are:-
  • Show Accounts grouped as Customer or Prospect depending on the opportunity stage
  • Show monthly performance of Salesteam on closing opportunity by Geography for current year
Note:- Charts cannot be made on Tabular Reports as no grouping of data is available

No comments:

Post a Comment

Get the Developer Name for Record Types without SOQL query

Hi, Previously, the developer name was accessible only via SOQL on the RecordType SObject, and not via describe information. Now you can ...