Advanced Reporting

About

Insightly's reporting system now incorporates subfolders to enhance list-view capabilities. 

There are two primary folders: System Folders, which encompass default standard report folders, and Custom Folders, allowing users to create top-level folders or nest them within others, extending up to five levels deep.

Additionally, both System and Custom Folders include a column called "Date Last Run," offering insights into when each report was last executed or viewed.

In this Article

Reports Overview

Insightly's Advanced Reporting object allows users to gather, customize, and review data regarding a wide variety of information located within Insightly CRM.

When accessing Reports via the objects on the left side, the Advanced Reporting Page will display two primary report folders: System Folders and Custom Folders.

System Folders

The system folders consist of the following five default folders, and none of them can accommodate user-created subfolders. 

  • Recently Viewed: It displays all reports ordered from the most recently viewed or run to the oldest.

  • Created By Me: This system folder showcases reports created by the currently logged-in user.

  • My Personal Reports: It showcases reports customized by the user.

  • Shared Reports: This is a system folder that displays the reports that have been shared with the user.

  • Standard Reports: This system folder showcases subfolders for various standard report types such as Task Report, Contact Report, Lead Report, Organization Report, Opportunity Report, and Project Reports. Additionally, it incorporates 'Other Reports.' Within the subfolders dedicated to standard object reports, you can discover related reports. For example, exploring the Task Report subfolder reveals three standard reports: Task Report, Task Linked Item Report, and Task Comment Report.

Custom Folders 

Users can create custom folders up to 5 levels deep.  Custom folders can be created as top-level folders or within any custom folder but not system folders. 

Create or Add New Custom Folder or Subfolder 

When the user selects the 'New Folder' button, the Parent Folder will be pre-selected, and a new folder will be created. Folders can be located using the search bar located on the left sidebar.  

When creating a folder, you can choose viewing permissions. Sub-folders will inherit the permissions of the parent folder. If a parent folder has permissions set to "Everyone," subfolders beneath it can still have restricted permissions. 

  • Everyone

  • Only the record owner

  • Select individual people

Edit or Delete Custom Folder or Subfolder 

To Edit or Delete custom folders, you can utilize the carat symbol, while editing subfolders is accessible through the actions (three-dot) menu.  


Bulk Move or Bulk Delete Folders or Subfolders

Bulk Move and Bulk Delete options are disabled for standard folders. 

  • Bulk Move: Sub-folders and Reports of a custom folder can be moved to another custom folder via Bulk Move button after the items are selected via checkboxes. 

  • Bulk Delete: Bulk Delete button allows users to collectively delete chosen custom reports and folders, directing them to the recycle bin. Only the Owner or Administrator has the authority to perform bulk deletions of custom folders or reports. When a non-administrator or non-owner attempts to bulk delete a selected report or folder, a message is shown: "Only the item creator or administrators can perform bulk deletions of selected items."  

Reports View 

  1. Report Folders contain saved reports and report templates. Click a folder to view the reports or templates it contains.
  2. The reports list displays the reports in the folder you've selected. You can search the folder by report name in the Search Reports field. To create a report based on a template, click a template name. To run a report you've saved, click the report name.
  3. A schedule icon and/or alert icon will appear if a report is set up to email a report at a scheduled time or when an alert is triggered.

You can select which of the columns appear in the reports list by clicking the Choose Columns icon and clicking the column names. Sort the displayed columns by clicking a header. 

Report Editor 

When creating a report from a template or editing an existing report, the report editor allows users to edit and save a report. The following options are available for all reports:

  • Close: Close and exit the report 
  • Save: Save edits and configurations that have been applied to the report
  • Run Report: Run the report and review the results
  • Report Properties: Apply a custom report name and save the report to a specified folder

Report Filters and Parameters

For additional information regarding report filtering, please review the Report Filters and Filter Logic article. 

The Report Filters and Parameters section can be utilized to edit default filters applied to reports as well as add new filters to customize reports; new filters can be added by clicking Add a Filter Row or by dragging and dropping a field from the Report Fields section. In the example below, the Email Performance Report has a default filter to display information from the last 90 days although (as with all reports), this filter can be edited or removed and additional filters can be added:

Icons in the upper right of the Report Filters and Parameters section allow for the following customization:

  • Filter Record by Owner: Display records that are owned by a specific user. 
  • Filter By Date: For reports that have a default filter applied to review the last 90 days, this option will already be enabled.
  • Configure Filter Logic: This configuration is available when three or more filter rows have been applied to a report. Please review the Report Filters and Filter Logic article for information on using filter logic.
  • Add Summary Field: This configuration can be added when a report includes a numeric field. Please review the Report Actions article for more information on adding a summary field.
  • Add Chart to Report: This configuration is available once a grouping has been added to a report. Please review the Report Actions article for more information on adding a chart to a report.

Report Fields

The Report Fields section displays fields that can be added to the report being viewed. These fields can be dragged and dropped to both the Filters and Parameters section and the report's Preview Grid. The fields displayed in this section are the same fields available when Add a Filter Row is clicked in the Report Filters and Parameters section. The field type are indicated by the icon next to the field name in the list:

  • a - Text fields
  • # - Numeric fields
  • Calendar icon - Date fields
  • Dropdown list icon - Custom dropdown lists
  • TF - True/False values. (For fields like Custom checkboxes which are checked/true or unchecked/false, and Completed tasks which are complete/true or incomplete/false).
  1. The icons in the upper right provide additional reporting options to filter by the records you own or by date, user filter logic when more than two filters are used, add a summary field, or add a chart to a report.
  2. From Filters and Parameters, you can add a filter by dragging and dropping a field name to this area. Click the icons in the top right to add additional filters, add logic functions for more than 2 filters, and add a summary row if your report includes a numeric field.
  3. Drag and drop fields to the Preview Grid to add them to your report and see a preview of the results. You can then drag a field name left or right to move the column, click a column header to change the sort order, drag and drop it up to the grouping area to group by values, or click the X next to the field name to remove it.
  4. You can search a particular report field by field name in the search bar on the left

Preview Grid

The Preview Grid allows users to review report data prior to running a report. Various configuration abilities are also possible within the Preview Grid

  • Export to Excel can clicked to export the report data into an Excel spreadsheet. 
  • Groupings can be created by dragging and dropping column headers into the groupings section. Once groupings have been created, a chart can be added to a report. Please review the Report Actions article for more information on adding a chart to a report.
  • Data columns can be removed by clicking the for the column.
    • Additional data columns can be added by dragging and dropping fields from the Report Fields section into the Preview Grid.
  • Date columns can have the date format configured by clicking the three dots menu in the date column. 

Report Layout

Once Run Report has been clicked on any report, the View Report page will display and is segmented into three sections:

Report_run-numbers1.png

Via the View Report screen, the Actions dropdown can be clicked to export the report into various formats; the option to print the report is also made available 

Report Generation Status

This section displays the total results of the report and will contain a numerical value of records that are included in the report. 

Report Schedule and Alert

In the event that a schedule and/or an alert has been setup for the report, this section can be reviewed for scheduling and alert information.

Report Filters and Parameters

Within the section, the filters that were applied in the Report Editor can be reviewed. Filters are read only in this section; to edit filters and rerun the report, the Pen icon (edit) can be clicked to return to the Report Editor.

Report Data

This section displays the report results in the same fashion as the Preview Grid in the Report Editor. This section will display up to 2000 results; if the report contains more than 2000 results, the report can be exported via the Export to Excel button or the options in the Actions dropdown. Once exported, the initial 2000 results can be reviewed as well as any results that exceed the initial 2000. 

Using the buttons above the report, you can:

  • Close the report and return to the Report Folders view.
  • Click the pencil/Edit button to edit the report.
  • Click the Actions menu to copy, edit, delete, print, or export the report. (You can also print it by clicking the printer icon in the upper-right.)
  • Set up a schedule or alert. (Available on accounts with paid subscriptions.) 


Was this article helpful?