How to produce custom reports and export data

Table Generator reporting is moving

Following helpful feedback from customers, we have made it easier to generate custom reports on the data in your ChurchSuite modules, moving away from Table Generator reports, which will be removed soon. The new workflow for generating custom tables of data provides users with greater control over the content of the output and more granular filtering to drill down into the data of interest within a module. The data can still be downloaded to a CSV file for reporting purposes.

Introduction

You can easily produce reports on the data in your ChurchSuite modules and export them to a CSV file. This may be helpful if you wish to retain a hard copy of certain data for historical record-keeping purposes or if you are migrating your ChurchSuite data to an alternative system. You might also use an export CSV file for a mail merge in an external word processing application.

Each module has a primary section listing all the core data for that module, presented in a paginated, ordered table. Module users will frequently visit these sections when performing their daily tasks. For example, in the Address Book, the Contacts section contains the core data for adult contacts in that module.

Click to see a larger version

In addition to standard reports in all modules, users can generate custom reports in the following modules and download the data to a CSV file or produce Address Labels and Name Badges. The primary sections include powerful Filters that allow users to drill down and view matching data of interest, and then perform Bulk actions for selected rows in the results table. Users can further customise the output by choosing the fields to be included in the download file, which can be readily viewed, further manipulated and printed from common spreadsheet applications like Apple Numbers and Microsoft Excel.

Module Primary section
Address Book Contacts
Children Children (and Visitors)
Calendar Events
Small Groups Groups
Giving Givers
Bookings Customers
Network Organisations

Choosing your data

Navigate to the primary section of the relevant module, in this example, the Contacts section for the Address Book module. The Search filters the list as you type, making it easy to find a record of interest using full or partial known details, such as a name. Here, we are filtering active contacts, but note the status Filter to switch between Active, Archived and Pending contacts.

Click to see a larger version

The data is paginated and, for multi-site customers, shows records for the Site being viewed by the User. The pagination controls located in the bottom-right corner of the page allow you to increase the number of records per page.

Click to see a larger version

You can customise the data columns shown, choosing from a list of available fields for the context or one of the preset views provided for common tasks. It's not possible to change the column order or add custom presets; however, customised columns chosen in this way are remembered for the logged-in user on their device, meaning that if they navigate away from the page or log out and later return, the previously selected custom columns persist:

Click to see a larger version

By default, each primary section in a module shows all data for the site being viewed, but you can further filter your data using the Filters. Choose from a wide range of one or more criteria for each module to drill down and see just the data of interest. For example, you can filter by Tags or Missing Data and even Pin a frequently used filter. Once a filter is selected, you can choose or select the filter criteria; the matching data updates immediately as each filter criteria is specified.

Click to see a larger version

Outputting your data

Use the available bulk actions to, for example, Send email, Send SMS, Download CSV or Print labels/badges. The bulk action respects the filters applied, and the number of selected records is displayed. You can also make a custom selection of ad hoc records from the list, and when selecting multiple records, you can easily select a series of records in a block - click the first checkbox in the block, then hold down Shift on your keyboard and click the last checkbox in the block - all of the checkboxes in between the first and last record are automatically selected:

Click to see a larger version

The Download CSV action opens a pop-up showing the previously selected custom or preset columns ticked. You can change the fields included in the output if you wish. Click Download on the pop-up to export your data. While the data shown on the screen is paginated, the CSV file and printed output contain all data matching your specified criteria.

Click to see a larger version

Clicking Print labels/badges opens a pop-up that allows you to produce Address Labels and Name Badges and, for the Address Book module only, a printable Contact Directory. While the data shown on the screen is paginated, the label, badge and directory preview contain all data matching your specified criteria. The last used label Format will persist on the user's device and be pre-selected when printing labels or badges in the future.

Click to see a larger version
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact ChurchSuite Contact ChurchSuite