Creating a Report
  • 4 Minutes to read
  • Dark
    Light

Creating a Report

  • Dark
    Light

Article Summary

Introduction to Reports

infoodle allows you to search and display information relating to various aspects of your organisation. However Reports produce information with a large scale design in mind, and can be fine tuned to show just the information you're looking for.

When creating the report parameters, you need to consider from where you want to obtain the data, how you might group that data together, and what information you want to display.

Selecting the Report type

  1. Select Reports from the Navigation Menu.
    image.png

  2. Select the type of Report to generate. Depending on the infoodle modules you've subscribed to, reports are generally based on Assets, Attendance, People, or People - Notes.

People - notes report and Permissions

The ability to create People - notes reports is tied to the Notes options in Role permissions.
If a user's role does not have the permission Can see general people notes they will not have access to the People - notes report functionality at all, even if they can access People reports.

Similarly, if a person can see and report on Notes, but is not in the associated group, any Note report they run will not list those notes.

This is because the Visibility Access restrictions apply to viewing the notes System-wide, so you can only report on notes that you are ordinarily able to see.

The one exception to Note visibility is if a User has added the Note themselves, and set it as visible to a Group, they will always see that specific note even if they are not part of that group. This is a very specific case where the person that added the note is always able to see the notes that they have added, so long as their role has that permission enabled.

For further information regarding Roles and Notes, see Roles - Viewing Notes on other Contacts

Create Criteria

The Create Criteria tab is the starting point for selecting the data you want to display.

  1. Select the drop-down and begin by choosing the criteria you want to add, or exclude from the report.
    image.png

  2. The second drop-down specifies range filters relative to the selected criteria.

    In the example below, the options specify an exact date, all dates before, and all dates after the specified date.

image.png

Other criteria ranges may filter results with:

  • starts with, ends with, contains (Address)
  • starting or ending numbers (of phone numbers),
  • equals or does not equal (Groups)
  1. The third field will be either a drop-down box for the selection from a list of related filters (specific age year when the Criteria is Age), or a text box for text you want to search for (a road name when the Criteria is Address).

    Depending on the initial Criteria, additional fields may also be displayed.

  2. Continue adding Criteria using the Add Criteria button. This will provides the option of adding additional criteria with the AND function. This results in all people that meet all of the criteria. That is, people that are in both of the groups (for example) and may not return many results.

  3. If you are looking for people in one or more groups then make sure that you use the OR function (as in the screenshot below). To select the OR function add one criteria and then click on the or button to add another criteria below.

image.png

  1. For Finance information, set the criteria to select the people of interest, then add a financial criteria to include the financial information for those people.

image.png

  1. When you choose a date field, for example, Date of Birth, and you select 'equals', you are presented with a choice of how to set the date - either a Specific date or a list of Preset date ranges.

image.png

Choose Grouping

Once you have selected all of your criteria select the Choose Grouping tab. The grouping tab allows you to select how you would like data in the Report to be sorted. This can improve the readability of the report.

image.png

Select Fields

The Select Fields tab displays all of the data fields and provides you with the ability to select what you want to have in the report.

image.png

Generate Results

The Generate Results tab provides options for:

  • Show - displaying the report directly on the screen
  • Download options - exporting the report as an Excel or CSV file
  • Further processing options
    • use the report results as destinations for an email
    • add the results to an existing or new group
    • add the results to a Work Queue for later processing.
  • Save report criteria - for information on this, see Saving a Report

image.png

Add to a Group

Selecting the Choose a group button leads to a new screen where you can either add the report results (Contacts - either individuals, or organisations or households) to an existing group, or as the basis for the creation of a new group:

image.png

If you select the option to Create a new group, after you have entered a name for the new group and selected Save, the group, with the report results (individuals or organisations/households), will be created immediately.

For information on printing the results, see: Printing a Report

Note

Most reports are created using the same steps but there are some Special reports in Infoodle which are slightly different. For example, Attendance.

Video

Was this article helpful?