Custom Reports

This page has various options that appear or disappear when you select the various reports. 

The first section is the fields you want to appear on the report, such as first name, last name, email etc. First Name and Last Name are selected automatically when you start a new report.

The second section is the report you want to run. Select "All Members" if you want to build your own report.

For example, to create a report showing all members with no emergency contact person set, select the following:

1. Select First Name and Last Name in the first section.

2. Select the All Members Report

3. Click the plus button to add a filter

4. Select the Members table

5. Select the Emergency Contact Person 1 column

6. Select Equal to in the Condition option

7. Leave the Value field blank

Click the "Run Report" button.

This will then list all members where the emergency contact person 1 field is blank.

To save a report so you can run it again later, click the green Save button above the results table. Saved reports are supported for "All Members", "Attendance" and "Attendance Numbers By Session/Date".

For an Attendance report, SwimClub Manager saves the selected dates, sessions, groups, attendance reasons, member type and member status. For an Attendance Numbers By Session/Date report, it saves the selected dates and session. Opening the saved report restores the report type and its saved options.

To delete a saved report, first, run the report you want to delete then click the Delete button next to the save button.

For example, if you added another filter to the above report for:

1. Emergency Phone 1

2. Equal to

3. blank

The query run on the database would be:

List all members where emergency contact person 1 is blank AND emergency phone 1 is blank.

OR Filters

To use OR filters, separate your values with a semi colon (;).

For example, to have a filter which includes all members in a group where the group name contains "Development" OR "Nippers", add a filter for:

• Groups

• Contains

• dev;nip

If you are filtering on a DATE field, such as Date of Birth, enter the date in yyyy-mm-dd format.