What are different kinds of reports in Salesforce?

There are four types of reports you can create in Salesforce, Tabular, Summary,Matrix and Joined Reports. Each are best suited for showing different types of data depending on what you want out of a report.

Tabular Reports – The images that I have shown you in this post have all been from a tabular report. This is the simplest of reports and is suited to just showing lines of data and nothing else. If you just want to show data with no preference to seeing totals, calulations or groups of data then this is the report for you just to keep it simple. It is also best to use this report type if you are planning to use it to export data.

Summary Reports – As soon as you click “Group by this field” as shown in the above image, you will turn the report into a summary report. Summary reports are probably the most commonly used and are great for showing groups of data e.g. If you want to see your recent accounts opportunities they will be grouped by account and you can see each opportunity under the account. From then you can do calculations, you can see the total amount of sales under an account, you can see the maximum, minimum and also average amount. You can also sub group fields by dragging them under the initial group.

Matrix Reports – Matrix reports are very similar to Summary but they allow you to group by rows as well as columns to see different totals. Matrix reports aren’t commonly used unless you have to display lots of complex data.

Joined Reports – Joined reports allow you to create two separate reports so that you can compare data. Again not most commonly used.

Thanks.

Hi,

In Salesforce we can Create 4 types of report formats

1. Tabular Reports: Simple listing of data without any subtotals. This type of reports provide you most basically to look your data. Use tabular reports when you want a simple list or a list of items with a grand total.

Example: This type of reports are used to list all accounts, List of contacts, List of opportunities…..etc.….

2. Summary Reports: This type of reports provide a listing of data with groupings and sub totals. Use summary reports when you want subtotals based on the value of a particular field or when you want to create a hierarchically grouped report, such as sales organized by year and then by quarter.

Example: All opportunities for your team subtotaled by Sales Stage and Owner.

3. Matrix Reports: This type of reports allow you to group records both by row and by column. A comparison of related totals, with totals by both row and column. Use matrix reports when you want to see data by two different dimensions that aren’t related, such as date and product.

Example: Summarize opportunities by month vertically and by account horizontally.

4. Joined Reports: Blocks of related information in a single report. This type of reports enables you to adopt five different blocks to display different types of related data. Each block can own unique columns, summary fields, formulas, filters, and sort order. Use joined reports to the group and show data from multiple report types in different views.