Working with Reports

TABLE OF CONTENTS [Hide]

Introduction
Viewing Reports
Creating Reports
Customizing Reports
Managing Report Folders
Scheduling Reports
Exporting Reports
Deleting Reports
Frequently Asked Questions

Introduction

In Zoho CRM, standard reports are provided in various modules, which can be either used as it is or customized further as per your business requirements.

You can perform the following operations in Reports module:

• View reports
• Create reports
• Create report folders
• Schedule reports
• Delete Reports
  

Viewing Reports

Zoho CRM provides 30 different standard reports for the benefit of the users, which are present under different module specific folders. You can use the standard reports or can customize as per your business requirements.

List of standard Reports

Report Name	Description
Account and Contact Reports
Contact Mailing List	Display the list of contact address details.
Key Accounts	Displays the accounts that give you more sales revenue.
Accounts by Industry	Displays the accounts from various industries.
Potential Reports
Pipeline by Stage	Displays the potentials by their stage.
Potentials Closing by this Month	Displays the potentials that are closing during the current month.
Sales Person's Performance Report	Displays the potentials gained by each sales person.
Lost Potentials	Displays the potentials that are lost.
Potentials by Type	Displays the potentials by their type.
Open Potentials	Displays the potentials that are pending.
Pipeline by Probability	Displays the pipeline of the potentials by their probability.
Sales By Lead Source	Displays the sales from various lead sources.
This Month Sales	Displays the sales that has happen during current month.
Today's Sales	Displays the sales that has happen today.
Lead Reports
Leads By Source	Displays the leads from various sources.
Leads By Status	Displays the leads and their status.
Today's Leads	Displays the leads that are created today.
Leads by Ownership	Displays the leads and the corresponding owners.
Converted Leads	Displays the leads that are converted into Account / Potential / Contact.
Leads by Industry	Displays the leads from various vertical industries.
Activity Reports
Tasks and Events Report	Displays the leads from various vertical industries.
Campaign Reports
Campaigns Revenue Report	Display the revenue generated from the campaign.
Campaign Leads	Displays the leads that are generated through the campaign.
Case & Solution Reports
Popular Solutions	Displays the number of comments for solutions.
Cases By Origin	Displays the cases based upon their origin.
Cases By Status	Displays the cases based upon their status.
Cases By Priority	Displays the cases based upon their priorities.
Cases By Comments	Displays the cases with the number of comments count.
Sales Forecast Reports
Quarterly Forecast Summary	Displays the quarterly forecasts that includes committed amounts, best-case amounts, and pipeline by quarter.
Forecast History Report	Displays the life cycle of the forecast.
Product Reports
Products by Category	Displays the products based upon their category.
Products by Support Termination date	Displays the products list whose support discontinued during the current month.
Products by Cases	Display the products and with the list of cases associated with the products.
Inventory Reports
Vendors Vs Purchases	Displays the vendors based on the purchases made from the vendors.
Contacts Vs Purchases	Displays the contacts based on purchases.
Purchase Orders by Status	Displays the purchase orders based on their status.
Quotes by Accounts	Displays the quotes based on accounts.
Quotes by Stage	Displays the quotes based on their stages.
Sales Orders by Accounts	Displays the sales orders based on accounts.
Sales Orders by Status	Displays the sales orders based on their status.
Invoices by Accounts	Displays the invoices based on their accounts.
Invoices by Status	Displays the invoices based on their status.

To access standard reports In Reports tab click the specific report (For example, Contact Mailing List from the Accounts & Contacts Reports) from the Reports folder (for example, Accounts & Contacts Reports, Potentials reports, and others).

To view the report

1. Click the Reports tab.
2. In the Reports Home page, select the report from the required module. (For example, Lead by Source from Leads module). The generated report is displayed with some of the fields.
3. In the generated report view click the Export to PDF button to print the report in PDF and Export to Excel button to save the report in *.XLS format.

Creating Reports

You can create new module-specific reports linking some of the other cross-functional modules. For example, you can create a report in accounts module linking other modules such as Contacts, Potentials, Quotes, and others.

List of Primary and related Secondary Modules

In the Create Report form, you need to specify the primary module and the related secondary modules (optional). The following table provides various primary and related secondary modules.

Primary Module	Secondary Modules
Leads	None
Contacts	Accounts, Potentials, Quotes, and Orders
Accounts	Potentials, Contacts, Products, Quotes, and Invoices
Potentials	Accounts, Contacts, and Quotes
Activities	Contacts
Products	Accounts and Contacts
Cases	Products
Solutions	-
Quotes	Accounts, Contacts, and Potentials
Orders	Contacts
Invoice	Accounts
Email	Leads, and Contacts

Types of Report

• Tabular Report: Displays the data without any subtotals in the report. Use this type of report to create contact mailing lists, consolidated view of sales pipeline, and others.
• Summary Report: Displays the data along with subtotals and other summary information.
• Matrix Report: Displays the data summarized in a grid against both horizontal and vertical columns.

Customizing Reports

You can create new reports according to your organization requirements. The customization of reports involves the following steps:

• Select the module and the corresponding cross-functional modules
• Select the report type (Tabular, Summary, or Matrix report)
• Select the report columns
• Group the columns
• Select the arithmetic functions
• Specify the advanced sorting filters
• Save the report in folder

Step 1: To select module and the cross-functional modules

1. Click the Reports tab.
2. In the Reports home page, click the Create New Report button.
3. In the Create Report page, do the following:
   1. Select the primary module from the Modules drop-down list
   2. Select the cross-functional modules from the Related Modules list box
4. Click the Continue button.

Select Modules

Step 2: To select the report type

1. In the Create Report page, under the Report Type tab, select one of the following report options:
   • Tabular Report
   • Summary Report
   • Matrix Report
2. Once you have selected the type of report, click the Columns tab

Select Report Type (Tabular, Summary, or Matrix type)

Step 3: To select the report columns

1. In the Create Report page, select the report columns to be displayed from the Available Columns list box to Selected Columns list box.
2. In the Selected Columns list box, change the fields order (if required).
3. Once you have selected the report columns, click the Grouping tab if you are using Summary Report otherwise click the Columns to Total tab.

Select Report Columns

Step 4: To group report columns

1. In the Create Report page, select click the Grouping tab (This is visible only if you have selected Summary reports under the Report Type tab).
2. In the Grouping page, you can group the columns up to three levels in ascending/descending order.
3. Once you have selected the report columns, click the Grouping tab if you are using Summary Report otherwise click the Columns to Total tab.

Group Report Columns

Step 5: To select the arithmetic functions

1. In the Create Report page, click the Columns to Total tab.
2. In the Columns to Total section, select the required arithmetic functions, such as Sum, Average, Lowest value, and Largest value for the available columns.
3. Once you have selected the arithmetic functions, click the Criteria tab to add additional report filters.

Arithmetic Functions in Report

Step 6: To specify advanced sorting filters

1. In the Create Report page, click the Criteria tab.
2. In the Criteria section, select the additional criteria for the report.
3. Once you have completed the report customization, do the following:
   • Click the Run: To run the customized report. Refer to Step 7 for saving the report in folder.
   • Click the Save: To save the custom report criteria.
   • Click the Cancel: To cancel the report customization.
4. Once you have completed the report customization, you can store the report in a folder.

Add More Criteria

Step 7: To save report in folder

1. In the Create Report page, click the Run or Save button.
2. In the Save Report dialog, do the following:
   • Report Name: Specify the report name.
   • Description: Specify any additional details about report.
   • Report Folder: Select the report folder in which the report has to be stored.
3. Click the Save. Refer to the Creating Report Folders section for folder creation.

Save Report in Folder

Managing Report Folders

By default, reports are stored in different categories. You can create personal/public folders so that you can store the frequently used reports in a common folder and access the reports easily

Create Report Folder

To create report folders

1. Click the Reports tab.
2. In the Reports home page, click the Create New Report Folder button.
3. In the Folder Details do the following:
   • Folder Name: Specify name of the folder.
   • Description: Specify additional information about folder.
   • Accessibility Details: Select one of the following options:
     • All Users are allowed to view this Template Folder: Select if you would like to enable the folder access for all the users.
     • Show this Template Folder only to me: Select if you would like to enable the folder access only to you.
     • Allow the following users to view this Template Folder: Select the users or user roles that can access the folder.
4. Click the Save. The new folder is created where you can add reports.

Note: All the report folders are publicly visible, but the reports within the folder can be made private.

Scheduling Reports

You can automatically send the reports to your colleagues, executives management and other non-Zoho CRM users by scheduling the reports daily, weekly, monthly or yearly. Once the Report scheduler is configured, report will be delivered to recipients as an email attachment (XLS format).

Schedule Reports

In the Scheduler Configuration page, you have to configure the schedule reports. The following table provides various field names in scheduling reports.

Field Name	Description	Remarks
Schedule Name	Specify the scheduler name	Mandatory field
Select Report	Select the report from the drop-down list	Mandatory field
Active	Specify the scheduler status	Checkbox
Start Date	Specify the start date of the scheduling the report	Mandatory field. The standard date format is mm/dd/yy
Start Time	Specify the time at which the report has to generated and sent to the recipients	Mandatory field. The standard time format is hh:mm
Repeat	Specify the frequency of the reports scheduler from the drop-down list. You can select one of the options. Daily, weekly, monthly, yearly, or specified time.	Drop-down list
Recipient Email	By default the logged in user's name is selected. You can also send the report to the other users by specifying the e-mail IDs.	Specify the e-mail IDs separated by comma

To setup report scheduler

1. Click the Reports tab.
2. In the Reports home page, click the Reports Scheduler button.
3. In the Scheduled Reports page, existing schedulers are displayed under the Scheduled Reports List section. Click the New Report Scheduler button.
4. In the New Report Schedule page specify the values (Refer to the Report Scheduler fields table) and click the Save button.

Exporting Reports

You can export the reports data in to XLS, CSV, PDF and HTML formats, which can be used for further data analysis purpose.

To export reports

1. Click the Reports tab.
2. In the Reports Home page, select the report from the required module.
   For example, Lead by Source from Leads module.
3. In the generated report view select the following options:
   • Export to Excel: To save the report in *.XLS format
   • Export to CSV:To save the report in CSV format
   • Export to PDF: To print the report in PDF
     

Deleting Reports

Periodically you may delete some of the unnecessary custom reports.

To delete reports

1. Click the Reports tab.
2. In the Reports home page, select the report to be deleted and click the Del link. The selected report is deleted.

Frequently Asked Questions

Q1. What types of reports are available?

Ans: You can create three types of reports namely, Tabular, Summary, and Matrix types of reports.

Q2. How to view reports?

Ans: All the standard and custom reports are available in Reports Home page. You can select the specific reports by clicking the Report link under Report folders.

Q3. Can I store all my personal reports in a folder?

Ans: Yes, you can store all your personal reports in a folder, which can be viewed only by you and users with System Administrator privilege. If required you can also make report folders publicly visible to other users in your organization.

Q4. Can I schedule my reports and send to my colleagues periodically?

Ans: Yes, you can schedule reports delivery. After scheduling, reports are sent to the recipients' e-mail ID with a link to access the specific report from the Zoho CRM - Reports module. You can also send the PDF document to the recipients. For more details on scheduling reports refer to the Scheduling Reports section.

Q5. Why I am unable to see some of the fields in Reports?

Ans: You may not be able to see some of the fields in reports if your administrator has disabled those fields. You can views fields that are displayed in your page layout. You can see the following set of data: Data to which you have the access (Read/Write) that includes records owned by you and shared by other users to you.