Custom Reports for Meaningful Insights and Decision-Making

 

Zoho FSM provides an extensive array of over 20 standard reports that deliver valuable insights into your field service management operations. These reports can be easily cloned and customized to fit your specific requirements better, allowing for greater flexibility in data analysis. We have now elevated our reporting capabilities by introducing the option to create Custom Reports from scratch. Whether you need to track technician performance, analyze customer satisfaction, or monitor resource allocation, the custom reporting feature in Zoho FSM enables you to generate reports that align perfectly with your business objectives.

 

Creating a custom report mainly involves three steps:

• Establish the module relationships
  
• Customize the report
  
• Run the report
  

Establish the Module Relationships 

You start with choosing the Primary Module, the root module from which the data for the report will be fetched. From this Primary Module, you then select the related modules whose data you need in your report. These related modules can be either a Parent or 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.

 

You can have up to four levels of parent-child relationships. You can also have multiple parent relationships.

 

 

For a child module, you can choose the Relationship Type. If you choose Inclusive, then in the report, all the records of the parent module will be included irrespective of whether they have records of this child module. If you choose Exclusive, then in the report, all the records of the parent module will be excluded if they do not have records of this child module.

 

Customize the Report 

Once you have established the module relationships, you proceed to customizing the report by adding the necessary columns. You can add columns from all the modules that you had selected previously. You can also group data by row and column and also include aggregate columns. You can reorder the fields or attributes.

 

Run the Report 

To see the data within a report, you need to run the report by applying the necessary filters. You can export the report to a file (Excel, CSV, PDF).

 

A Sample Custom Report - Technician Performance 

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.

 

Choose Service Resources as the primary module. Add Service Appointments as a child module to Service Resources and Trips as the child module of Service Appointments.

 

 

To customize the report, add the columns Distance Traveled, Duration, and Actual Duration. Deselect Service Resource Name and Trip Name. Choose ServiceResource Name for Row Groups. 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). Similarly, add another Aggregate Column Avg of Actual Duration. This will help you assess the Mean Time to Repair (the time it takes to complete an appointment).

 

When you run the report, the results will be displayed as shown below:

 

 

Refer to our help documentation for more details. Feel free to contact at us support@zohofsm.com for any queries.

• Topic Participants

• Latha Velu

  

• Recent Topics

• Add home page or dashboard in CRM customer portal

  is it possible to add home page or dashboard in CRM customer portal?

• User Tips: How to change the the label display name of a system defined field

  Most users know how to change field label names via Settings > Modules & Fields but if you want to change the name of a system defined field you can’t as there is no “edit properties” option.  However with a simple hack you can edit any system defined

• Search not working!

  I have items in my notebook tagged but when I search for a tag nothing comes up! Any fix for this?

• Zoho CRM Community Digest - October 2025 | Part 1

  Hello Everyone! Here's a quick recap of first two weeks of October! Product Updates: Zoho CRM Android App Update: Surveys, Blueprints, and Smarter Mobile Features! Zoho CRM’s Android app just got a useful upgrade. You can now share records, upload your

• Automate onboarding emails with CRM Workflow and Accounts module

  We’re a B2B SaaS company selling to public-sector organisations. Each organisation is stored as an Account in Zoho CRM, and each organisation typically has multiple associated Contacts. Our backend syncs product-usage data (setup status, user activity,

• Important update: Enhanced security measures for account operations in Zoho Cliq

  Greetings from the Zoho Cliq team! We’d like to share an important security update that has an influence on some admin actions such as password reset, MFA reset, and MFA backup code generation. What’s changing? With our latest security enhancements, these

• Sales Receipts Duplicating when I run reports why and how do we rectify this and any other report if this happens

  find attached extract of my report

• No Functional Autosave or Manual Save Button

  Application : Zoho Notebook So I wanted to try Zoho Notebook(On Ubuntu) as an application, I installed the application and went solving my LeetCode problems visually(Drawing mode), at one point the app just stopped saving anything... Every time I tried

• Enterprise subscription support

  My organization sells subscription services to enterprise customers, which is a different model from the consumer subscription model that Zoho Billing has been designed to support and I beleve this capability should be added. An enterprise subscription

• Issue with Creator's IF logic

  Hi, I found the following code produces unexpected results: if(-1.0 < 0.0000000) {       info "True"; } else {       info "False"; } if(-1.0 < 0.000000) {       info "True"; } else {       info "False"; } The output returned is: False True However, the

• Need option to send Package PDF in shipment email (Shipment PDF is missing Lot info)

  Is there any way to automatically attach the Package PDF instead of (or alongside) the Shipment PDF in the notification emails? We really need this feature because the default Shipment PDF creates a blind spot for our customers. It does not display Batch/Lot

• zoho creator view is not present in the workspace and blank reports

  Hi Support,  Users who have "write" permissions keep getting this error for all of our embedded reports all of a sudden. See screen shot below: Meanwhile, my developer permissions account sees a blank screen in view and edit mode as shown in the screenshots

• Customize portal email template

  Can i fetch only first name of the user in portal email template instead of the below code Hi ${User.FULL_NAME}

• Can't we let users decide which options they'd like to add at embed widget?

  It seems embed widget DOES NOT offer a feature, where users can choose options upon subscribing plans. What Zoho has instead, is that admins have to manually create plan with options. How come no one in Zoho dev team never raised issue about usability

• Reupload and rename from one field to another field (file upload)

  Hi Everyone, Sorry, i have question to use invoke url for rename and reupload attachments file to another field. Tested on development mode. Zoho C6. Refer to https://www.zoho.com/creator/help/api/v2/upload-file.html look my error notification. Does anyone

• Printing Multi-Page Reports (PDF Export)

  Hi, I am moving a report from Google's Looker Studio to Zoho Analytics and trying to reproduce the Looker page by page dashboard editing experience. With Google, what you see is what you get when you print to PDF. But I can't seem to create the same experience

• I NEED TO NUMBER TO TEXT NO HERE

  =NUMBERTEXT NEEED

• Error: View is not present in the workspace

  When saving a dashboard, user receives a popup with the following error. "View is not present in the workspace" What does this mean or refer to? There is no further insight given.

• Dear Zoho CEO: Business Growth is about how you prioritise!

  All of us in business know that when you get your priorities right, your business grows. Zoho CRM and Zoho Books are excellent products, but sadly, Zoho Inventory continues to lag behind. Just this morning, I received yet another one-sided email about

• Bin Locations

  Dear all, I am wondering if someone has the ability to develop the bin locations option for zoho inventory (integrated with zoho books) Regards, Ryan

• Create and populate a record in an instant: Introducing zero-shot field prompting to Zia's ICR

  A couple of months ago, we upgraded our in-house AI image detection and validation tool, Zia Vision, with intelligent character recognition (ICR). By training Zia with sample images, you could create and enrich CRM records with data extracted from standard

• How to Prevent Users From Skipping LMS Videos in Zoho People

  How to Prevent Users From Skipping LMS Videos in Zoho People Hello Zoho Developers, In this blog, we will quickly look at how you can stop users from skipping or fast-forwarding videos in Zoho People LMS. Zoho People provides a feature called Disable

• [Integration Edition] Deluge Learning Series – Custom API with Deluge | November 2025

  We’re excited to conclude this four-month Integration Edition of the Deluge Learning Series: Session 1 – Integrating Zoho Apps with Deluge Using Built-In Integration Tasks Session 2 – Integrating Zoho Apps with Deluge Using invokeURL and invokeAPI Session

• Tips for Organizing Workflows and Improving Team Coordination in Zoho

  Hi everyone, I’m looking for some general advice on how different teams are organizing their daily work within Zoho’s apps. Our team recently expanded, and we’re trying to streamline how tasks, discussions, and documents are shared so everything stays

• Prevent user from viewing all records?

  I have a report that is meant to be used by vendors to view only the records that are assigned to them. All the vendor information is stored in a separate application, so I need to call a function to get the current user's ID (not the zoho user ID). The report settings criteria doesn't support using function calls, so instead I'm embedding the report in an html page like this: if (thisapp.Global.CurrentUserIs("Vendor")) {       personID = common.getLoggedInPersonID();       query = "Assigned_Vendor.ID="

• Zoho Site pages not displaying in iframes

  I simply want to show a Zoho Site page inside an iframe on another non Zoho website. When testing this across many browsers, the iframe content simply does not appear. IE reports that the host does not allow their content to be displayed in iframes. Very disappointing. Is there a way around this please? Here is the URL of the page I would like to appear in an iframe. http://ips-properties-to-rent.zohosites.com

• ZUG Meet-ups are back - Across India (December 2025)

  The Zoho User Group (ZUG) meet-ups are back, and this time, we’re travelling across India to reconnect with our amazing community! From Chennai to Delhi, Bengaluru to Mumbai, we can’t wait to meet you all in person and talk everything Zoho SalesIQ, automation,

• Zoho Inventory as connector in Zoho Creator

  Hello, It doesn't appear that Zoho Inventory is one of the many built in connectors in Zoho Creator? I see that there are non-Zoho inventory applications that have built in connectors such as Cin7, which leads me to believe that I'm missing something

• Send Zoho Forms Link using Zoho CRM Email Templates

  I have set up Zoho Forms and CRM integration to pre-populate data from Zoho CRM to Zoho Forms. The setup is working fine. I have also created an email template in the Zoho CRM deals module to send Zoho forms links. So when I send an email using that template

• My go to On Load Client Script - Fast, efficient, and works for ALL profiles; Hides everything except initial fields

  This is my on Load client script that I use for Create pages. I use a modified version for Edit and Display pages which you can create yourself using the same basic structure that I will give you below. First up, the script. Below that will be an explanation

• Custom Search using HTM+CSS Snippet

  Suppose I wanted to create my own list view using HTML and CSS snippets inside a Page with a custom search input at the top of the list (not the Search snippet). Without Javascript, is there a way to retrieve a user's entry from that search input and

• Zoho CRM Kiosk Upload Files

  Hello all, We are trying out Kiosks at the moment to see where it can fit best in our business. We are still a bit off in the application but lets say we will sort this out. My question is the following - when I create a Kiosk I can add "File Upload"

• Double opt-in notifications and customizable confirmation messages for your webforms

  Dear CRM Community, We are excited to announce a major upgrade to our Webforms feature. You can now customize the confirmation message shown to your users who double opt-in from your webform and also customize your confirmation emails when they submit

• Has Anyone successfully integrated Zoho and Sage Intact?

  Hey all, We’re evaluating Zoho One + Sage Intacct and I’m trying to connect with anyone who has actually implemented the two together.Specifically, I’d love to know: -- Which functions you kept in Zoho vs. Intacct (e.g., Product Catalog, AR/AP, invoicing,

• Introducing Image Upload Field

  Hello everyone, In this post we will discuss about the benefits and usage of the Image upload field. The field is available for standard and custom modules.  Usage: This field can be used to upload a gallery of images to a record and share the record with peers or customers. The record can be made accessible to users outside of Zoho CRM via Portals, where they can upload the necessary images. Preview, editing, and deleting images: The uploaded images can be directly edited and saved from the record

• Trigger a Workflow Function if an Attachment (Related List) has been added

  Hello, I have a Case Module with a related list which is Attachment. I want to trigger a workflow if I added an attachment. I've seen some topics about this in zoho community that was posted few months ago and based on the answers, there is no trigger

• Free webinar alert on November 19 - Email driven strategies - Master personality based styles

  Hello Zoho Community! Want to make email management easier, smarter, and more you? We’ve got just the session for you! Join our interactive, game-based webinar to discover how Zoho Mail adapts to your personality and work style. Learn practical hacks,

• AI generated meeting notes associated to Account or Deal

  As our organization works to improve efficiency we are looking for a solution to leverage AI to generate meeting notes and then add those notes to a CRM record such as an Account or Deal. I see Zoho has a Notebook AI offering that talks about the ability

• due date on cheue

  how to handle cheque in zoho books for customers and vendors including due date

• Conta META desativada. Problema no uso do CRM Zoho e SalesIQ.

  Olá, Habilitei um número Whatsapp no SalesIQ em Agosto/2025 com sucesso. Agora concluí a configuração do Zoho CRM e ao habilitar o Whatsapp, descobri que a conta META foi desativada: Configurar CRM -> Canais -> Mensagem de negócio -> WhatsApp Você não

• Next Page