Hi folks, Here we will see how to create a simple Tabular Report in Salesforce. This is the most simple type of Report format that displays data similar to a spreadsheet. The Tabular report simply consists of fields as consists of fields as columns, with each matching record list in a row.
How to Create Tabular Report in Salesforce?
Tabular reports are used to display data as similar to a spreadsheet. As this report is easy to set up, while tabular reports do not allow you to group data.
Let’s create a simple Tabular Report in Salesforce. In this example, I am using a scenario like I need to display All the Closed Won Opportunity related to Active Account.
The first you start off by creating a Report Type. A report type defines the set of records and fields available to a report based on the relationships between a primary object and its related objects. Reports display only records that meet the criteria defined in the report type.
Step 1- Create Report Type
To create report type, from setup search for Report Type and click New Custom Report Type Button. Enter the Required details and Click on the Next button.
On next step Choose Account as primary object and Opportunity as a Child object.
Click on the Save Button. I am done with creating Report Type. Now let’s move ahead to Creating a Report.
Create Report:
To Create a Report, navigate to Report tab and click on the New Report button. Select Record Type called Account with Opportunity under Opportunity folder and click on the Create button.
Drag the required fields from the left section into the report area.
Add Filter:
To add filters you need to add fields from the left bar into the highlighted area.
- Drag the Active field from Account object and set to Yes.
- Drag Stage field from Opportunity object and set to Closed Won.
Run the report and final outcome should look like this.
View More:
- How to fetch records from sobjects using REST API in apex class salesforce..
- Field Dependencies in Salesforce.
- Validation Rule in Salesforce.
- Batch Apex in Salesforce,
Conclusion:
I hope you would love this post. Please don’t hesitate to comment for any technical help. Your feedback and suggests would be helpful for me
Thank You.