Advanced Member Report

This report will allow you to collate any or all information that is collected from your members on your registration form. You can create it and adjust it to your liking.    

Firstly, login to your Online Membership Database - If you don’t have your login details please contact your State Governing Body or Association.

1. Click on Reports in the menu to open the 'Reports Manager'. 

2. By default, the Reports Manager offers 8 different categories of reports:
-Clearances
-Clubs
-Competitions
-Contacts
-Finance
-Members 
-Teams
-Tribunal  

The categories of reports available will differ depending on the sport and the level of database access, e.g. 'teams' reports are not available at the team level. Click on the category of reporting you wish to use.  

3. A range of report titles will appear related to the reporting category you have selected. Click 'Configure' on the report that you want to generate. In this case, click configure on 'Advanced Member'.         


 

4. Down the left hand side are the categories of database fields available to include in your report. Click on one of these categories to expand the list to show all fields available within that category. Use the scroll bar to navigate up and down the list of fields.          

5. To select a field to include in your report, click on the field, and while holding down the mouse button, drag and drop the field into the 'Selected Fields' area.          

6. You can now filter the report to only show specific data/ records for this field.     

7. Continue to add all the fields that you want to include in the report by dragging and dropping them into the 'Selected Fields' area. The position of fields can be re-ordered by dragging and dropping them into the desired order.    

8. Once you have added all of the required fields, scroll down to the 'Options' area. The options available are:    

a) Show:      

- Unique records only   
- Summary data    
- All records      

b) Sort by:     Select a field from the drop-down list that you want to sort the report by, and select the sort order - ascending or descending - from the next drop down list      
c) Secondary sort by: If you wish to apply a secondary sort, select a field from the drop-down list and select the sort order (ascending or descending) from the next drop down list      
d) Group by: To group the data under headings, select a field from the drop-down list. For example, you could group your member data by club, team, member type (Player, Coach, Official, etc) or season.    

11. Once you have set your sort and grouping options, scroll down to 'Report Output'. Select one of the two options: - Display: open the report in a new screen on your Internet browser - Email: email the report as a text file, suitable to be imported and modified in another program. If you wish to use this option, you must enter a valid email address into the 'Email Address' field.    

12. The final option available is to save the report. This will enable you to generate this same report again in the future at the click of a button, without having to go through the process of selecting and setting up all the fields and options again. Click here for instructions on saving reports and running saved reports.    

13. When you have finished setting all of the parameters for the report, click on Run Report.  Your report will be generated according to the output method selected.