Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
classsection group
<span data-swiftype-index="true">
classcol span_3_of_5

Lengthy reports that have lots of data can be difficult to analyse, and it can take some time to produce the reports. In these cases you're better off filtering the reports to show just the relevant information you need, and then sorting the data to your liking.

For example, if you need a report showing a particular customer's payments for the months of May to June, you can filter the Customer Payments report to show details for the one customer and just for those two months. You can then sort the report by date or amount if it helps.

Wanting to add more data to a report? See Add and remove report columns.

UI Expand
titleTo filter a report

To filter a report

  1. Open the report you want to view and click the Filters tab (if it's not already selected).

  2. If you want to change the date range, enter or select a new date range or period in the Dates section. Note that date filters are unavailable for some reports.
  3. In the Refinements section, select values for the various filters. The example below shows the options available for the Item List [Summary] report.

    AClick Run Report to apply filter changes.
    BClick Sort to sort the order of information in the report.
    CSelect values for filters to limit the data that will be included in the report. Depending on the report you are producing, you may be able to filter by card type, custom lists, tax codes, amounts, etc.
    DClick Additional Filters to set filtering options that are not visible in the tab. Only available if the report you're running has more filters available. See step 4 below.
    EClick to return all filters to their default values.
  4. If you want to apply more filtering options, click Additional Filters and complete any filters you want to apply.

    Note that the options available in this window depend on the report you are viewing.
  5. Click OK. The Reports window reappears.
  6. Click Refresh Report to apply the new filter settings.
UI Expand
titleTo sort a report

To sort a report

  1. Open the report you want to view.
  2. In the Filters tab, click Sort. The Sort window appears.

  3. In the Sort by field, select the column you want to sort the report by, then select which order you want to sort that information in.
    For example, to sort a report alphabetically by name, select Name, then select Ascending in the adjacent field.

  4. If you want to add additional sorting levels, click Add Sort Level, then select the type of information you want to sort by and the order you want to sort it in.
    In the example above, the report will first be sorted alphabetically by name, and if there are multiple entries for the same customer, those rows will be sorted by the amount.

  5. Click OK. The report is sorted in the specified order.

UI Text Box

Preparing financial reports? Financial reports, such as your profit and loss statement, are reported by financial year, and can't be filtered to a calendar year.

These reports can only be filtered to show information for the last, current or next financial year. If you haven't closed the previous financial year, the Financial Year filter will show a prior year as the "current" year. If you're still not ready to close the previous year, you'll need to select the Next Year option when preparing your reports for this financial year.

Saving your changes

If you like the way you've filtered and sorted your report, you can save it as a custom report.

UI Expand
titleTo save custom reports

To save custom reports

  1. With the report displayed, click the save icon ( Image Added ) at the top of the window. The Save report as window appears.
  2. Enter a name and a brief description of the custom report.
  3. Click Save.

To run the report later, select it from the My Custom Reports tab in the Index to Reports window.

Image Added

classcol span_1_of_5


classcol span_1_of_5
titleRelated topics

Add text and pictures to a report

Add and remove report columns

Saving and deleting custom reports

titleFrom the community

RSS Feed

More »