You can run one off reports on demand or schedule recurring reports to run automatically. To run the report you fill out the reports form which creates a report definition, which tells Evergreen how to run the report, what information to include, and what type of output to provide you with.
Tip
Examples of how to fill in the report definition for commonly used report templates can be found in Appendix C, Report Definition Examples.
- Go to Administration → Reports
In the My Folders section click on the arrow beside the Templates folder to see your template folders. Use the arrows to expand the folder tree until you find the folder containing the template you would like to use for your report.
Click on the folder name to display the contents.
- Check the box beside the template you wish to use.
Create a new report from selected template will be selected by default. Click Submit.
Enter a name for your report.
Optionally, enter a description for your report.
The display columns included in the output are listed as Report columns.
Pivot Label Column and Pivot Data Column are optional. Pivot tables are a different way to view data. If you currently use pivot tables in MS Excel it is better to select an Excel output and continue using pivot tables in Excel. Please note that Pivot tables are only suitable for some types of result data.
Choose the Reports folder you would like to save the reports definition in.
Enter values for any filters. For more information on filter values see the section called “Report Filters”.
Note
Instead of scrolling through the options in the filter lists you can click on one of the visible options and then on your keyboard press the letter the option you want starts with. This will jump you to that spot in the list.
Check the boxes to select the types of output you would like.
Check the Calculate grouping subtotals check box to add an unlabeled row or column with the subtotals for each grouping and an unlabeled grand total row or column. Please note group subtotals and grand totals will only be useful with some reports.
Leave the recurring and run time options as is unless you are running a recurring report. See the section called “Recurring Reports”.
Optionally, enter an email address to send the report completion notification to. By default this field will contain the email address saved in your staff account. Additional addresses can be added separated by a comma.
Note
The email will contain a link to the password-protected report output. Only staff members with permissions to view reports or full access to the reporter will be able to open the report output. Staff who only need to view report output must first to fill out the All Staff Reporter Privacy Waiver.
Choose the Ouput folder you would like to save the report output in and then click Save Report.
- A pop-up appears confirming the report has been saved. Click OK.
- Unless you have set a specific run time the report will run right away. If your report has not completed after 15 minutes please contact Co-op Support.
- Once the report is complete you can view your output. See the section called “Viewing Report Output”.
The filters in a report template allow library staff to set the parameters on which the report runs. The ability to select values for certain filters when running a report means a single report template can be used multiple times to generate reports on slightly different data. For example, the same report template can be used to generate separate lists of items using particular circulation modifiers.
Hardcoded filters are set when the report template is created. These filters cannot be changed when running a report. Common hardcoded filters include:
| Column | Transform | Action | User Params | Description |
|---|---|---|---|---|
Bibliographic Record → Record ID | Raw Data | Not in list | -1 | Exclude all records where the bibliographic record ID is -1 which is all pre-cat records. |
Call Number/Volume → Call Number/Volume ID | Raw Data | Not in list | -1 | Exclude all records where the call number ID is -1 which is all pre-cat records. |
Circulation → Check In Date/Time | Date | Is NULL | Include only items that have not been checked in. | |
Circulation → Circulating Item → Copy Status → Name | Raw Data | Equals | name of an item status | Include only items that are in the specified item status. |
Circulation → Fine Stop Reason | Raw Data | Not in list | LOST | Exclude items that have stopped generating fines because they have been set to lost. |
Item → Is Deleted | Raw Data | Equals | f | Include only un-deleted items. |
ILS User → Is Deleted | Raw Data | Equals | f | Include only un-deleted patrons. |
Date filters are generally set up to be a specific date, a specific month, or a date range. Date filters will often include tips about how the dates should be entered. For instance, in a date range the earlier date should always be entered in the first date box.
If you’d like to include all possible data for your library in a report that specifies a time range, enter between "1900-01-01" and "today’s date".
When running recurring reports it’s very important to use Relative Dates in your filters. This will allow Evergreen to calculate the time period to report on each time it runs the report. A relative date of 1 month ago will generate a new report each month on the previous month’s data; a real date of November 2022 will generate the same report each month with the data from November 2022.
Tip
You can set up recurring monthly reports to show comparative data from one year ago. To do this select relative dates of 1 month ago and 13 months ago.
Use the drop down menu to switch from Real Date to Relative Date. For a report filtering on month, you will be able to indicate how many months ago the report should look at.
All report templates used by libraries will include a library filter. This filter can look at the library specified in a variety of fields in the data including the checkout library, circulation library, owning library, patron’s home library, and organizational unit.
This filter is important as it allows staff to comply with Sitka’s data use requirements as per Appendix J of the Service Management Agreement and restrict the data in the report output to only data relevant to their library.
Multi-branch libraries can add specific branches or all of their branches to the list to get a report including data from the select branches.
While many filters will require staff to select values from a given list, some filters will require staff to type a value into the filter User Params field. In those cases the report will generally indicate how the text should be entered so that Evergreen can use the value and generate usable report output.
Some report templates will have just hardcoded filters and a single library filter that requires staff to enter a value while other reports will have multiple filters where staff need to enter values for the library, dates, and patron or item data.
Save time by scheduling recurring reports to run your regular reports automatically. Monthly circulation and patron registration statistics are good candidates for recurring reports.
Staff with access to the reporter can set up recurring reports to email a link to the password-protected report output to another staff member. Staff who only need to view report output must first to fill out the All Staff Reporter Privacy Waiver.
To set up a recurring report, follow the procedure in the section called “Running a Report” until you reach step 11 and then follow the steps below.
- Check the box for Recurring Report.
Select your desired Recurrence Interval. Reports can run on a daily, weekly, or monthly interval.
Tip
The recurrence interval should correspond to the date filter. For example, if the template filters on a date instead of month, a recurring report running with a monthly interval may miss a day or capture an extra day’s data. See the section called “Date Filters” for more information on working with date filters on a recurring report.
Check the box beside the date and set the date of the first run of the report.
Note
Best practice is to always set recurring reports to run in the early hours of the morning (1:00am PT to 4:00am PT).
Monthly recurring reports MUST be set to run on the 1st of the next month in order to capture all monthly data.
Enter an email address to send the report completion notification to. By default this field will contain the email address saved in your staff account. Additional addresses can be added separated by a comma.
Note
The email will contain a link to the password-protected report output. Only staff members with permissions to view reports or full access to the reporter will be able to open the report output. Staff who only need to view report output must first to fill out the All Staff Reporter Privacy Waiver.
Choose the Ouput folder you would like to save the report output in and then click Save Report.
- A pop-up appears confirming the report has been saved. Click OK.
- Unless you have set a specific run time the report will run right away. If your report has not completed after 15 minutes please contact Co-op Support.
- Once the report is complete you can view your output. See the section called “Viewing Report Output”.
