---
title: How to use an adhoc report?
description: ChurchTools comes standard with several typical ad hoc reports that provide answers to questions about congregational development and ChurchTools usage. The reports are always run immediately and therefore reflect the current state of affairs. Statistics Adhoc reports are statistical data.…
url: "https://churchtools.academy/en/help/churchtools-modules/adhoc-reports-en/how-to-use-an-adhoc-report/"
updated: "2026-10-28"
category: "Report / AdHoc-Reports"
---

# How to use an adhoc report?

ChurchTools comes standard with several typical ad hoc reports that provide answers to questions about congregational development and ChurchTools usage. The reports are always run immediately and therefore reflect the current state of affairs.

Statistics

Adhoc reports are statistical data. This means that a basic understanding of how to interpret statistics is necessary to understand the reports.

## Run an Adhoc report

Under Adhoc Reports (1), select the desired query (2) and specify the desired report (3) if there are multiple options. If report filters exist for the selected query, they will be displayed on a second line.

Once you've selected everything, click "Execute request" (4) to start, and you'll see the result.

[![Screenshot Report Adhoc reports](https://churchtools.academy/wp-content/uploads/2022/01/Report_Adhoc-reports-1024x279.png)](https://churchtools.academy/wp-content/uploads/2022/01/Report_Adhoc-reports.png)

## Statistics Settings

The query results are displayed in the center. By default, the chart type specified in the master data for the adhoc report is used (see [[How do I create a new ad hoc report?]]).

[![Screenshot Report Adhoc report details](https://churchtools.academy/wp-content/uploads/2022/01/Report_Adhoc-report-details-1024x599.png)](https://churchtools.academy/wp-content/uploads/2022/01/Report_Adhoc-report-details.png)

(1) You can change the chart type at any time.
(2) The same applies to the aggregation of the data.

**Note**

Not every aggregation and chart type is appropriate for every situation. You'll need to make the right choice here so that the data is displayed correctly and you can interpret it.

(3) This section displays the fields from the query that are not yet being used in the current report. If you want to use them, simply drag and drop them into the column or row (4).
(4) Fields in the query that are used as columns or rows in this view.

Multiple fields can be used for the column or row display. This groups the values.
For example, this allows you to compare reports not only by year but also by year/month.

Order of the fields

Please note that the order of the fields in the column/row is important. For example, the display for "Year/Month" is different from that for "Month/Year."

## Read more

- [What are adhoc reports?](https://churchtools.academy/en/help/churchtools-modules/adhoc-reports-en/what-are-ad-hoc-reports/)
