Generating Reports | Zoho Workerly

Generating Reports

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

Types of Report

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

Create Reports

You can create new reports according to your organization's requirements. The customization of a report 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 calculation functions
  • Specify the advanced sorting filters
  • Save the report in folder

Availability

Profile Permission Required: Users with the Reports permission can access this feature.

Note
  • On sharing a report that you have created with other users in your organization, note that all fields in the report will be visible to them, even though some users may not have the permission to view some fields.


Part 1: To select a module and the cross-functional modules
  1. Click the Reports tab.
  2. In the Reports Home page, click Create Report.
  3. In the
     
    Create Report
     
    page, do the following:
    • Select the primary module from the drop-down list.
    • Select the cross-functional modules from the Related Modules list box.
      You can use the fields from the Related Modules in defining the criteria, in adding columns in your report and select columns to total.
  4. Click Continue.

Part 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

Note

  • When you select the Summary Report, the Grouping tab will also be available.
  • You can Run or Save the report at any point while creating it.
  • When you click the Run button, the system will prompt you to save the report. The report is saved temporarily and then a preview of the report is generated.
  • When you click the Save button, the report is saved in the folder that you specify.

Part 3: To select the report columns

  1. In the Create Report page, click Columns tab.
  2. Do the following to select the columns to be displayed in your report:
    • Select the columns from the Available Columns list box.
    • Click Add.
    • The columns will be added to the Selected Columns list box.
    • Use the Up and Down arrow keys to sort the display order of the columns.
    • Select the column name and click to delete the selected column.
  3. Click Save.
    In the pop-up window, specify the Report NameDescription, and Report Folder details.
  4. Click Run to save the report first and then run it.
  5. Once you have selected the report columns, click the Grouping tab if you are using Summary Report otherwise click theColumns to Total tab.
Part 4: To group report columns

Note

  • The system will display the column names (in the Columns tab) only for those modules that you select here.
  • In the Create Report page, click the Grouping tab.
    This tab will be available only when you select Summary Reports under the Report Type tab.
  • In the Grouping page, you can group the records based on the grouping criteria that you specify.
  • Select the values from the respective lists.
  • Select Ascending or Descending from the list.

Part 5: To select the calculation functions

  1. In the Create Report page, click the Columns to Total tab.
  2. In the Columns to Total section, select the required calculation functions ( SumAverage, Lowest ValueLargest Value ).

Part 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 one of the following:
    • Click Run to preview the report.
    • Click Save.
    • Click Cancel.

Note

  • You can also use a Record's Created By and Modified By fields to define criteria.


Part 7: To save the report in a folder
  1. In the Create Report page, click Run or Save.
    Note, that you can run the report only after you save it.
  2. In the
     
    Save Report dialog box, do the following:
    • Enter the Report Name.
    • Enter the Description of the report.
    • Select the Report Folder in which the report has to be stored.
  3. Click Save.

Edit Criteria Patterns

Criteria Pattern Editor in the report helps you to define advanced filters using simple logic like and/or.
Availability


Profile Permission Required
: Users with the Reports & Dashboards permissions can access this feature.

Note

  • You can specify a maximum of 25 criteria in a report.


To edit criteria patterns
  1. Click the Reports tab.
  2. From the list of reports, click the Edit link for the corresponding report in which you want to edit the criteria pattern.
  3. In the Customize Report page, click the Filters tab.
  4. Review your existing criteria and click Save.
  5. Save the modified report.


Important Notes

  • When the Change Pattern box is open, you cannot add or delete a criteria row under the Specify Criteria section.
  • The operator precedence will not be taken into account if you do not specify brackets. For example, if you specify the criteria as 1 or 2 and 3, it will be considered as ((1 or 2) and 3)
  • You can change the and/or of the criteria rows and it will be updated in the Editor below.
  • You can change the and/or condition in the pattern and it will be updated in the rows above.
  • If you specify 1 and 2 and save it, on editing the report the pattern will be shown as (1 and 2). For (1 and 2) or 3 the pattern will be shown as ( (1 and 2) or 3 )
  • If you add more rows in the editor and delete one by one there will be additional brackets displayed in the pattern. For example, if there are 4 rows added and you delete the 3rd row, the criteria pattern will be as ( ( ( ( 1 and 2 ) ) ) or 3 ). If the first row is deleted then it will be shown as ( ( ( ( 1 ) ) ) or 2 ). However, on saving the criteria, it will change as ( 1 or 2 ).
  • Make sure that you do not use the following as they are invalid: ()(and)(or)
  • If the brackets do not match it will be treated as invalid.
  • There will be an error message if the number of rows and the numbers given in the pattern does not match and also if there are any missed numbers in the pattern specified.
  • Save and Cancel buttons on the report will be hidden while editing the criteria pattern.
  • In case the final brackets are missing, there will be a difference in the Criteria Patterns Editor and its view mode.
Your Criteria Pattern in Editor
Your Criteria Pattern in View Mode
( 1 and 2 ) or ( 3 and 4 )
(( 1 and 2 ) or ( 3 and 4 ))
1 and 2 and 3 and 4
(1 and 2 and 3 and 4 )
( 1 or 2 ) and ( 3 or 4 )
( ( 1 or 2 ) and ( 3 or 4 ) )

Use 'Last Activity Time' in Criteria

The time when any change is made to a record, be it adding a note, closing a task, sending emails or just editing the fields is captured under "Last Activity Time". The information in this field can be used in Reports criteria, to filter out records that had no activity for a specific period of time or those records that had recent activities.

Note

  • This option is supported only in the Temps, Timesheets, Clients, Contacts and Jobs modules.
  • These modules should be selected as the Primary module or should be one of the Related modules.
  • While Last Activity Time under list view criteria captures all updates made to a record, the Last Modified Time will only capture changes made to the fields and does not include changes made to the NotesTasks, or Email sections.
  • These criteria can be used in all types of reports.
Availability


Profile Permission Required
: Users with the Reports & Dashboards permissions can access this feature.


The activities and updates that will be recorded as Last Activity time:
    • Editing fields in a record

    • Adding & updating activities, i.e. Events, Calls

    • Sending emails to candidates and contacts

    • Adding & editing notes

    • Adding jobs & contacts under an account

    • Changing the owner of the record

    • Adding and deleting a record
      (This does not include deleting a record associated to the parent record.)

    • Closing a task

    • Deleting and restoring the records (individually or in bulk).

    • Mass operations such as Mass Update, Mass Transfer etc.
      (Except for the Mass Delete option.)

The activities and updates that will NOT be recorded as Last Activity time:

  • Deleting related lists under a record.

Create Report Folders

By default, reports are stored in different categories. You can create personal or public folders to store the frequently used reports in a common folder for easy access.

To create report folders

  1. Click the Reports tab.
  2. In the Reports home page, click Create Folder.
  3. In the
     
    Create Folder
     
    page, do the following:
    • Enter the Folder Name.
    • Select
       
      Accessibility Details:
      • Everyone: Select if you would like to enable the folder access for all the users.
      • Only Me: Select if you would like to enable the folder access only to you.
      • Selected Users: Select the users or user roles that can access the folder.
  • Click Save.

View Reports

To access standard reports in the Reports tab click the specific report (For example, Jobs opened this month from the JobsReports) from the Reports folder (for example, Timesheets Reports, Jobs reports, and others).

To view the report

  1. Click the Reports tab.
  2. In the Reports home page, click the required reports group.
  3. From the list of reports that are displayed, click the required report's link.
  4. Click the Edit link to modify the Report Name, Folder details and Description of a report.
  5. In the
     
    Reports
     
    page, you can do the following:
    • Export: Use this option to export and save the report in Excel, PDF, or CSV format in your local dirive.
    • Save As: Use this option to save the report with a new name. This option is useful when you filter a specific set of data and save it for future reference.
    • Reload: Use this option to update or refresh the contents of the page.
    • Hide Details / Show Details: Click Hide Details to hide the details of the report and click Show Details to see the hidden details of the report.
    • Create Chart: This feature enables you to create charts, (such as Bar diagrams, Pie charts, Line charts, Funnel charts) based on the selected report details.
  6. Do one of the following, and then click
     
    Apply Filter
     
    to view reports based on the filter options specified:
    • Select Last Created Time or Last Modified Time from the Column list.
    • Select the option from the adjacent list. (Next FQ, for example).
      On selecting this option, the system will automatically display the Start and End date in the respective boxes.
    • Enter the Start Date and the End Date in mm/dd/yyyy format, or select the date from the calendar displayed.

Note

  • A maximum of 2000 records will be listed in a page. You can use the navigation options to view others pages.
  • You will be able to export up to 2000 records per page, in each export.
  • FQ refers to Financial Quarter and FY refers to the Financial Year.

Delete Reports

Periodically, you may delete some of the unnecessary reports. Please note that you can delete the reports created only by you. Also, you need to have the Manage Reports permission in your profile.

To delete reports

  1. Click the Reports tab.
  2. In the Reports home page, click the Delete link corresponding to the report that you want to delete.

    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









                                            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

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      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 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

                                                                                                              • Working with Reports

                                                                                                                Zoho Workerly reports are the detailed and informative list of records. Each report provides access to important data required for various purposes. In Zoho Workerly, standard reports are provided in various modules, which can be either used as it is ...
                                                                                                              • Generating Invoices

                                                                                                                An Invoice is a document issued to your clients, detailing out the client name, job details, working hours of temps and much more. It lists the individual temp workers, their duration for a job, and the amount payable for each of them.  How do I ...
                                                                                                              • Home Currency

                                                                                                                Home Currency is the primary currency that your organization uses for its business. Often this is the currency used to generate annual reports and calculate the company's income.  Before you start using this feature, the Administrator in your ...
                                                                                                              • Attaching from Local Drive

                                                                                                                You can use this feature to attach documents, spreadsheets, and presentations to the records from your local drive. To attach files from local drive Click the [Module] tab. Module refers to Temps, Clients, etc. In the [Module] Home page, select a ...
                                                                                                              • Day Rates

                                                                                                                With day rates in Zoho Workerly, you can use the Full Day and Half Day settings while generating timesheets. With minor changes to the usual steps for creating jobs and timesheets, you can enable day rates in your Workerly account. Scenario:  ...
                                                                                                                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