How to create a custom report

With Insightly's advanced reporting, you can pick and choose which fields to display in a tabular report, filter and summarize them by specific values, and save and share the reports you create.

To create a new report

  1. Go to the Reports tab in the left navigation menu.
    Adv_reporting_m1.png
  2. Click the New Report button in the upper right. You can also select a report type from the Insightly template folders on the left and skip to step 5.
    Custom_rep1.png
  3. Select a report type from the list. You can search the list by typing in a record name, like "Prospect" or "List." Different report types give you access to different kinds of information.Custom_rep2.png
  4. Click the Create button to begin building your report.
  5. Drag and drop fields from the Report Fields list on the left to the preview grid to add them to your report. You may add up to 30 fields. The grid will display a preview of the first 200 items as you build your report.
    Custom_rep3.gif
  6. Add filters to narrow or expand your results by dragging and dropping fields from the list to the Report Filters and Parameters area or by clicking Add a Filter Row. You may add up to 8 filters.
    Custom_rep4.png
  7. Enter the operators and values that match your requirements, and then click the Add button. Filtering is not case-sensitive.
    Custom_rep5.png
    For relative date fields, click the information icon to select options like "Last 90 days." This lets you build and save reports for regular monitoring.
  8. Move your cursor over the filter and click Edit or Remove to remove a field filter or edit the parameter.
  9. The quick filter icons at the top right of the Filters and Parameters area let you create additional filters for the record creator and date created and are applied when the filter is ran.

    For example, if you set up a quick filter for "My Prospects" and share the report, each of your colleagues will see only the Prospects they created when they run the report.
  10. Click the Configure Filter Logic icon above the filters if you have more than two filtering criteria and want to nest your filters. (The icon won't activate unless you have more than 2 filters.)

    This will give you access to a formula bar to create your filtering logic using simple Boolean operators—AND, OR, and parentheses.
    Custom_rep6.png
  11. To further customize the view, drag a column header left or right to move the column, drag and drop it up into the grouping section to group by values, click the X next to the field name to remove it, or click a single column header to change the sort order.
  12. To see calculated summaries for numeric fields—like a sum total, average, count, or minimum or maximum value—click the Add Summary Row icon.
    Custom_rep7.png
  13. Click the chart icon to add a chart to your report. You'll need to have at least one grouped value to build a chart.
  14. Save the report by clicking Save.
    Custom_rep8.png
  15. Enter a report name and choose the folder where you would like to save the file. You can also create a new folder.
    Custom_rep9.png
  16. To see the results of your report, click the green Run Report button. Insightly will display up to 2,000 records in your browser. If there more than 2,000 results in the report, you can view all of them by clicking the Actions button above the report and selecting an export option.
    Custom_rep10.png

You've now saved a report that can be run at any time by selecting it from your report folder. If you have a paid subscription, you can also have the report emailed to you with schedules and alerts.

Was this article helpful?