Difference between revisions of "Reports"

From Online Support Wiki
Jump to navigation Jump to search
Line 118: Line 118:
 
| Is Not Empty || Example
 
| Is Not Empty || Example
 
|-
 
|-
| Before || Example
+
| Before || Generally used for dates, this option would be used when looking for dates that are "before" a certain date. For example, you could use this when looking for Membership Start Dates that are earlier than a certain date.  If I wish to find all memberships started prior to 1/1/2018, using the '''Membership Report''', my filter option would display as shown below. [[File:Mem Start Date.jpg|800px|center]]
 
|-
 
|-
| After || Example
+
| After || Generally used for dates, this option would be used when looking for dates that are "after" a certain date. For example, you could use this when looking for Membership Start Dates that are later than a certain date.  If I wish to find all memberships started after 12/31/2017, using the '''Membership Report''', the filter would be as shown below: [[File:After criteria.jpg|800px|center]]
 
|-
 
|-
| Between || Example
+
| Between || Generally used for dates, this option would be used when looking for dates that are "between" two dates. For Example:If I wish to find all memberships started after 12/31/2017 and before 1/1/2019, using the '''Membership Report''', the filter would be as shown below:
 +
[[File:Between Criteria.jpg|800px|center]]
 
|-
 
|-
| Greater Than|| Example
+
| Greater Than|| Generally used for numeric or monetary values, this option would be used when you wish to find results that are more than (but not equal to) the value you specify. For Example: If you wish to find all contacts who owe you more than $500.00, using the '''Accounts Receivable Detail Report''', the filter would be as shown below.
 +
[[File:Open Balance Greater.jpg|800px|center]]
 
|-
 
|-
 
| Greater Than or Equal|| Example
 
| Greater Than or Equal|| Example
 
|-
 
|-
| Less Than|| Example
+
| Less Than|| Generally used for numeric or monetary values, this option would be used when you wish to find results that are less than (but not equal to) the value you specify. For Example: If you wish to find all contacts where accounts receivable aging is less than 30 days, using the '''Accounts Receivable Detail Report''', the filter would be as shown below. [[File:Less than.jpg|800px|center]]
 +
 
 
|-
 
|-
| Greater Than or Equal|| Example
+
| Less Than or Equal|| Generally used for numeric or monetary values, this option would be used when you wish to find results that are less than or equal to the value you specify.
 
|}
 
|}
  

Revision as of 18:48, 20 March 2019

Your GrowthZone software provides a variety of reports which will help you to analyze all aspects of your business.

Common Report Functions


Export Reports


All Reports may be exported to Excel or PDF. The reports may be exported in detail or summary format (Detail vs. Summary results will vary dependent on the report you are working with)

  1. Define the desired filters for your report.
  2. Click the down arrow on the Run Report button.
    CP Run Report.jpg
  3. Click the desired export format:
    • Export as Excel
    • Export Summary as Excel
    • Export as PDF
    • Export Summary as PDF

Email Reports


You can easily send report results via email. Perhaps the board would like a report of all Dropped Members, generate the report and email the results.

  1. Define the desired filters for your report.
  2. Click the down arrow on the Run Report button.
    CP Run Report.jpg
  3. Click Email Report.
    CP Email Report.jpg
  4. Enter the To email address.
  5. The Subject' will default to the name of the report. You may change this as needed.
  6. Enter your message.
  7. (Optional) Select a signature from the drop-down list.
  8. (Optional) Select a communication Category.
  9. Select how you would like to attach the file from the Report Format, Attach or In-line. Best Practice is to attach Inline as email messages with attachment are more prone to going to SPAM.
  10. Select whether you wish PDF, Excel or CSV as the Document Format.
  11. Click Send.

Add Report Contacts to a List/Committee


You can easily create a list from a report. For Example: If you wish to communicate with your dropped members, you can generated the Dropped Membership Report, and create a list. You can then easily communicate with these contacts.

  1. Define the desired filters for your report.
  2. Click the down arrow on the Run Report button.
    CP Run Report.jpg
  3. Click Add to List.
    Add Contacts to List2.jpg
  4. From the List/Committees drop-down, select the name of the list to which you wish to add members (this option will allow you to add the members to an existing list) OR click the Plus icon.jpg to create a new list. See Working with Lists/Committees for further instruction on creating the list.
  5. Select the Replace existing contacts if you wish to replace all of the contacts in an existing list with the results of your report.
  6. Click Done.

Save a Report as a New Report


With all of the reports, you have the ability to apply custom filters. After customizing the report to suit your needs, you may save the report as a New Report. This will make it easy for you to run the report again in the future as your custom settings and filters will be saved.

To Save a Report as a New Report:

  1. Define the desired filters for your report.
  2. Click the down arrow on the Run Report button.
    CP Run Report.jpg
  3. Select Save As New Report.
    Add Save Report.jpg
  4. Enter a Report Name.
  5. Enter a Description.
  6. Hide This Report From Other Users: Select this option if the report is only to be used by you. It will not be available for other users.
  7. Click Done.

Smallest.png

Did you Know: You can also use a Saved Report, to create and save another New Saved Report. Simply follow the instructions above from your Saved report.

Save a report as a Favorite Report


If you frequently use the same report, you can save it as a favorite.

  1. For the desired report, click the down arrow on the Run Report button.
    CP Run Report.jpg
  2. Click Add as Favorite Report.

When you access the Reports module, in the Show Only drop-down list, select Favorites.

Filter on Favorite.jpg

Report Filtering Options


Reports are built to include recommended fields, however, you may customize the report to get more granular in the information that you are looking to analyze. For Example: When working with the Dropped Membership Report, if you wish to view a list of the members that have dropped for a certain reason, you can generate the report by setting the Criteria / Filters.

Use the following procedure on all reports, to set filtering criteria.

  1. In the Criteria / Filters section, click the Plus icon.jpg icon.
  2. Select the field on which you wish to filter from the drop-down list. The fields available will vary based on the report you are working with.
  3. Select the desired Operator. Operators will vary dependent on the field you have chosen. The operators is used to specify the condition that must be met to be included in your report. Available operators are described below.


Operator Description
Is Equal Use this operator to look for results that are exactly equal what you input into the text box. For example, if running the drop report searching for members who have dropped because membership was too expensive, you would select Is Equal and type Too Expensive in the text box.
Is Not Equal Use this operator to exclude from your report results what you have input into the text box. For example, if running the drop report, and you would like to see all of the members who dropped, except those who dropped because membership was too expensive, you would select Is Not Equal and type Too Expensive in the text box.
Starts With Use this operator to look for results where the beginning of the field begins with the letters that you have input into the text box. For Example, if running the Event Discount Activity Report, and you are
Contains Example
Not Contains Example
Ends With Example
Is Empty Example
Is Not Empty Example
Before Generally used for dates, this option would be used when looking for dates that are "before" a certain date. For example, you could use this when looking for Membership Start Dates that are earlier than a certain date. If I wish to find all memberships started prior to 1/1/2018, using the Membership Report, my filter option would display as shown below.
Mem Start Date.jpg
After Generally used for dates, this option would be used when looking for dates that are "after" a certain date. For example, you could use this when looking for Membership Start Dates that are later than a certain date. If I wish to find all memberships started after 12/31/2017, using the Membership Report, the filter would be as shown below:
After criteria.jpg
Between Generally used for dates, this option would be used when looking for dates that are "between" two dates. For Example:If I wish to find all memberships started after 12/31/2017 and before 1/1/2019, using the Membership Report, the filter would be as shown below:
Between Criteria.jpg
Greater Than Generally used for numeric or monetary values, this option would be used when you wish to find results that are more than (but not equal to) the value you specify. For Example: If you wish to find all contacts who owe you more than $500.00, using the Accounts Receivable Detail Report, the filter would be as shown below.
Open Balance Greater.jpg
Greater Than or Equal Example
Less Than Generally used for numeric or monetary values, this option would be used when you wish to find results that are less than (but not equal to) the value you specify. For Example: If you wish to find all contacts where accounts receivable aging is less than 30 days, using the Accounts Receivable Detail Report, the filter would be as shown below.
Less than.jpg
Less Than or Equal Generally used for numeric or monetary values, this option would be used when you wish to find results that are less than or equal to the value you specify.

Types of Reports

Membership Reports

Membership Change Report - This report lets you create a report for all new memberships, upgrades, downgrades, re-activations, and adjustments to membership.