Custom Reports

Custom Reports

Use Custom Reports to extract and analyze data that is most relevant to your operations, performance metrics, and business goals. You can pull data from various modules within Zoho FSM, such as contacts, work orders, trips, service resources, addresses, etc. You can include the required data fields from these modules.

Info
- Permission Required: Create of Reports
- Find out the Edition-specific limits for Custom Reports.

Create a Custom Report

To create a custom report:
  1. Select the Reports menu and click Custom Reports from the left panel.
  2. Click Create Report.
  3. In the Create New Report popup, select a primary module.
    The primary module is the root module from which the data for the report will be fetched. E.g. If you choose the Service Resources module, you can fetch details such as the appointments the field agents have worked on, time taken by them to complete each appointment, etc and thus assess their performance.
  4. Enter a name in the Report Name field.
  5. Add the other related modules from which you want to include data in your report and click Save.
    The name field from each of these modules will be added as columns.
  6. Customize the Columns, Row Groups, Column Groups, or Aggregate Columns and click Save.
  7. In the Report Details popup, enter a Report Name, Description of the report, the Folder in which you want the report to be listed, and click Save.
You can choose the related modules from which you want to include data in your report.
  1. Click on to add a Parent module or to add a Child module.

    A Parent of a module corresponds to all the lookup fields in the module. E.g. For the Work Orders module, the parent modules will be Companies, Contacts, Requests, etc.

    A Child of a module corresponds to all the related lists in the module. E.g. For the Service Appointments module, the child modules will be Service Reports, Time Sheets, Trips, etc.

  2. For the Child module chosen, select a value for Choose Relationship Type and click Submit.

    Inclusive: If you choose this, then in the report, all the records of the parent module will be included irrespective of whether they have records of this child module.

    Exclusive: If you choose this, then in the report, all the records of the parent module will be excluded if they do not have records of this child module.
To make any changes to a child module, click on the Edit [] icon. Click on the Delete [] icon to remove a module.
 
Note: In a report, you can include data from a total of six modules, of which you can have a maximum of four child modules. 

Customize the Report

  1. Click + for the element (Columns, Row Groups, Column Groups, or Aggregate Columns) you want to add to the report.



  2. Select the fields or attributes you want to add to your report and click Apply.
    You can filter these by modules or data type. The existing fields or attributes in the report will be selected. Uncheck the ones you want to remove.



    You can reorder the fields or attributes. Hover over a field or attribute and click on  to drag and drop it.



  3. Click Save.
The selected fields or attributes will be added to the report.


Edit a Custom Report

Info
Permission Required: Edit of Reports

To edit a custom report:
  1. Select the Reports menu.
  2. Click on the custom report you want to edit.
  3. Select Edit from the dropdown button in the top right corner.



  4. Make the necessary edits and click Save.
To change the report name, click the Edit [] icon next to the report name. In the Report Details popup, edit the Report Name and click Save. Click Save in the report.

Delete a Custom Report

Info
Permission Required: Delete of Reports

To delete a custom report:
  1. Select the Reports menu.
  2. Hover over the custom report you want to delete and, under More options [], select Delete.
  3. Click Yes in the confirmation message.

Run a Report

To see the data within a report, you need to run the report. To do so:
  1. Go to the desired report and click Run from More Options []. You can also simply click the report name.
  2. Choose the necessary filters and click Apply.
    Please bear in mind that by default, the criteria in the filters will correspond to the primary module. You can change it as needed. E.g. if the primary module is Service Resources, then by default the value in the Date & Time filter will be Created Time. This Created Time will be that of the Service Resource. You can change it to another value, say, Created Time (Service Appointments).

Sample Custom Report 

Let's see how we can create a sample custom report called Technician Performance. This report is meant to assess the appointments done by the field agents by evaluating the time it takes to complete an appointment and how long it takes technicians to travel to a job site. To create this report:
  1. Select the Reports menu and click Custom Reports from the left panel.
  2. Click Create Report.
  3. In the Create New Report popup, select Service Resources as the primary module.
  4. Add Service Appointments as a Child Module to Service Resources and Trips as the Child Module of Service Appointments. In both these child modules, choose Inclusive as the Relationship Type.
  5. Click Save.



  6. In the left pane under Columns, Service Resource Name, Appointment Name, and Trip Name will be listed. Deselect Trip Name. Add the columns Actual Duration, and Distance Traveled.
  7. Select ServiceResource Name for Row Groups.
  8. Select Avg of Duration for Aggregate Columns. This will help you assess the Mean Time to Travel (how long it takes technicians to travel to a job site).

Info
Points to remember
  1. In a report, you can add a maximum of 30 columns.
  2. In a report, you can add a maximum of three groupings, row-wise and column-wise combined.
  3. In a report, you can add a maximum of four aggregate columns.  

      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        Access your files securely from anywhere

          Zoho CRM Training Programs

          Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

          Zoho CRM Training
            Redefine the way you work
            with Zoho Workplace

              Zoho DataPrep Personalized Demo

              If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

              Zoho CRM Training

                Create, share, and deliver

                beautiful slides from anywhere.

                Get Started Now


                  Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                  BOOK A SESSION







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsEnterpriseOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceAccessible Forms
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Intake FormsLegalMobile App
                              Form DesignerHRMobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic Forms
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsEncrypted Forms

                              Secure Forms

                              WCAG

                                      Create. Review. Publish.

                                      Write, edit, collaborate on, and publish documents to different content management platforms.

                                      Get Started Now






                                                        You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                            Manage your brands on social media

                                                              Use cases

                                                              Make the most of Zoho Desk with the use cases.

                                                               
                                                                

                                                              eBooks

                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                               
                                                                

                                                              Videos

                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                               
                                                                

                                                              Webinar

                                                              Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                               
                                                                
                                                              • Desk Community Learning Series


                                                              • Meetups


                                                              • Ask the Experts


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner

                                                                Zoho Sheet Resources

                                                                 

                                                                    Zoho Forms Resources


                                                                      Secure your business
                                                                      communication with Zoho Mail


                                                                      Mail on the move with
                                                                      Zoho Mail mobile application

                                                                        Stay on top of your schedule
                                                                        at all times


                                                                        Carry your calendar with you
                                                                        Anytime, anywhere




                                                                              Zoho Sign Resources

                                                                                Sign, Paperless!

                                                                                Sign and send business documents on the go!

                                                                                Get Started Now




                                                                                        Zoho TeamInbox Resources





                                                                                                  Zoho DataPrep Demo

                                                                                                  Get a personalized demo or POC

                                                                                                  REGISTER NOW


                                                                                                    Design. Discuss. Deliver.

                                                                                                    Create visually engaging stories with Zoho Show.

                                                                                                    Get Started Now









                                                                                                                        • Related Articles

                                                                                                                        • Customized Reports

                                                                                                                          As editing the Standard reports is not permitted, you have the option to clone these reports and tailor them to meet your specific needs. Create a Customized Report Permission Required: Create of Reports To create a customized report: Select the ...
                                                                                                                        • Standard Reports

                                                                                                                          Permission Required: Reports A report will only include data from records for which the user has View permission. List of Reports Select the Reports menu to view the following out-of-the-box FSM reports: Report Name Description Field Technicians - ...
                                                                                                                        • Service Reports

                                                                                                                          A service report can be created for an appointment. It will capture the details of the service appointment, the associated contact details, and other inputs of customer acknowledgment such as signature, and rating. Available in Editions: All Editions ...
                                                                                                                        • Email Customer the Service Reports along with the Invoices

                                                                                                                          Usecase: When a service appointment is completed, email to the customer the service reports in the service appointment and the invoices in the parent work order. Follow the steps below to implement this usecase: Step 1: Create connections Step 2: ...
                                                                                                                        • Why can’t I disable certain permissions while creating a custom profile in Zoho FSM?

                                                                                                                          In Zoho FSM, certain permissions are mandatory and cannot be disabled—even in custom profiles. The non-editable permissions include: Basic Permissions: Contacts, Companies, Work Orders, Service Appointments, Trips, Timesheets, Job Sheets, Services ...
                                                                                                                          Wherever you are is as good as
                                                                                                                          your workplace

                                                                                                                            Resources

                                                                                                                            Videos

                                                                                                                            Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                            eBooks

                                                                                                                            Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                            Webinars

                                                                                                                            Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                            CRM Tips

                                                                                                                            Make the most of Zoho CRM with these useful tips.



                                                                                                                              Zoho Show Resources