How helpful was this page?
Related Blog Posts
Prepping for winter break
Dec 01, 2020
Lost books? Remind your patrons about them!
Nov 11, 2020
What's due soon?—Relative dates
Nov 04, 2020
New Patron Details—We listened to your feedback!
Sep 09, 2020
Keeping patrons informed—Email notices
Aug 26, 2020
Reporting and policies—How are they related?
Jul 10, 2020
End-of-year prep—Item clean up
Apr 08, 2020
End-of-year prep—Disable emails
Apr 01, 2020
When are my books due?—Send Patron Details to everyone
Mar 04, 2020
Get your books back!—Scheduling overdue notices
Jan 29, 2020
Alexandria makes it easy to build your own frequently-used, custom reports. The Saved tab contains custom reports that you (or others) have created, saved, and shared.
Select a report from the Report Selection pane to populate the Selected Report pane below. Saved reports tabs—Overview, Selections, Options, Notification, Schedule, and FTP—contain settings that are essential to how your reports are ordered, organized, and presented.
Saved reports can be run, modified, duplicated, or removed.
Saved reports only keep the selection criteria used to create the report, not the results of the report itself.
Lock/Unlock. Click the padlock to unlock the record for editing.
- Duplicate Report. Should you want nearly identical settings for a custom-created report, this allows you to make a copy of the selected Saved report, give it a new name, and make whatever changes you require.
- Delete Report. Permanently delete the selected saved report.
Switch Site. In a Central Union, click this icon to change the site you're working in.
Operations Management. Go to Operations Management to view and download your finished reports.
Support. Having trouble? This will open support documentation for this topic in another tab.
Reports are organized in categories and subcategories. Click the arrow to expand or contract the subcategories. Select a category or subcategory title to view the list of associated reports in the Report Selection pane. For example, if you want to run a Charges and Overdue Fines report, there are three ways to find it:
- Select All Reports.
- Select the Circulation category.
- Expand the Circulation category and then select the Charges and Payments subcategory.
Remember, the list of available reports depends on both the category/subcategory you've selected and whether you're in the Quick or Saved tab.
Report Selection Filters
Once you've selected a category or subcategory, the associated reports will be listed in the Reports Selection pane on the right. You can further narrow your the list of reports using filters. In some ways, these filters far surpass the usefulness of the Categories pane. In fact, you may find yourself never using the Categories filters again, preferring instead to use the All Reports category in conjunction with the filter bar.
Favorite. See the reports marked as Favorite.
Operator. See reports you (the current operator) have saved.
Filter. Enter a term to filter by report title.
Filters can be applied in various ways. For example:
- To see only copy label-related reports, select the Copies category and type "labels" in the filter bar.
- To see all types of label reports, select the All Reports category and type "labels" into the filter bar.
- To see all shared label reports, select the All Reports category, select the Shared filter, and type "labels" into the filter bar.
Once you've sufficiently narrowed your filter criteria, scroll through the Report Selection list to locate and select the specific report you would like to view, modify, or run.
Create a Saved Report
- Go to Tools > Reports.
- With the Quick tab selected (default), use the Categories pane and report filters to locate and select the template you want to use.
- At the bottom of the Selections tab, click Create Saved Report.
- Enter a name for the new saved report (optional), then click OK.
- Modify the settings in each tab, then click Save.
Having trouble with a Saved report? It's possible that the template you used to create it has changed or was removed, causing problems with your saved report Try recreating the report with a Quick reports template. See Legacy Reports for more information.
The Overview tab serves as a report summary, including the title (e.g. Mrs. Smith - Overdues), report creator, usage notes (e.g. Run this report weekly!), and allows you to mark it as a favorite.
Enter or edit the name of the report here (e.g. Dr. Linus - LOST books).
This information is automatically populated with the report creator's name and site ID code.
You can provide general usage notes about the report here (e.g. Report created for Marjorie - Run daily!).
When this option is checked, the report is classified as a “favorite.” This is especially helpful if you find yourself running the same reports regularly.
The Selections tab is where you build the report to suit your needs. If you find some of your reports lacking the necessary selection information, try checking the Show Additional Selections box for more options. The settings in this tab vary per report.
Say you wanted to run a Loaned Items report for staff and middle school students only. How do you let Alexandria know to leave everyone else out? Some report selections have a dropdown menu with the option to include or exclude multiple policies. The logic of OR and AND NOT Boolean operators is used in these advanced selections.
Dropdown menu options:
- Any Policy: All policies will be included.
- Include: Only the policies you check will be included (OR). Patrons do not need to concurrently belong to all selected policies to be included.
- Exclude: All policies except the ones you check will be included (AND NOT).
Once you select Include or Exclude, a Set button will appear to the right of the dropdown menu. Click on it to check the boxes of policies you want to include or exclude in the report, and click Set when you're done.
Choose the sort and format options here. The settings in this tab vary per report.
Use these settings to schedule this report to run on a regular basis.
Check this box to unlock the Saved report scheduling capabilities.
This dropdown menu allows you to specify how often you would like to repeat your Saved report. You can select Once, Daily, Weekly, Monthly, Yearly from this drop-down menu. Secondary On options may dynamically appear, depending on your selection
Choose the time of day, including a.m. or p.m., to run the report.
If you want confirmation that your reports are being performed at the indicated times and sent to the appropriate people, check the Enable Email Notification box and provide email addresses in the fields below.
- For example: firstname.lastname@example.org
You can provide more than one email address separated by commas.
- For example: email@example.com,firstname.lastname@example.org
Enable Email Notification
Check this box if you want to enable email notification, sent upon report completion.
Email Notification and Download Link To
In this field, provide the operator email addresses that Alexandria will use to send confirmation emails, a link to the Operation Summary, and a link to download the report.
Email Notification To
In this field, provide the email addresses that Alexandria will use to send notification emails when the report has finished printing and a link to the Operation Summary; you can provide more than one email address separated by commas.
Alexandria can save finished reports to an FTP server. These options allow you to specify the (secure) FTP server address and uername/password credentials.
Upload Report to FTP Server
Check this box to set up your this option allow you to specify your (secure) FTP server URL and username/password credentials.
If you'd like a more secure transmission that hides the username/password and encrypts the file content, FTP can be secured with SSL/TLS (i.e. “ftps://”). Be aware that the name “Secure FTP” can be confusing because it refers to two completely different protocols: “SFTP” and “FTPS”. Whenever the term Secure FTP is used, it is necessary to specify whether the SSH-based or SSL-based file transfer protocol is meant. Alexandria supports FTPS; the SSL-based file transfer protocol.
Enter the host name or IP address of the FTP server without the URL protocol. For example,. Don't worry about including the URL protocol/scheme (e.g. “ftp://”) as this is automatically appended before the host name depending on your Protocol selection (above).
While FTP typically runs over TCP port 21, FTPS (SSL/TLS) typically runs over port 21 or port 990. If you don't have permission to open multiple ports, both unencrypted FTP and encrypted FTPS will run over port 21.
Enter the full path including directories and filename, such as /directory/subdirectory/filename.txt
Username and Password
Enter your FTP login credentials. If your FTP server is Provide a clear-text authentication and sign-in protocol in the form of a username and password. If your FTP server is configured to allow it, you can connect anonymously without having to enter anything
If you find yourself uncertain what an FTP server actually is, it's essentially just a software application that uses the File Transfer Protocol (i.e. FTP), a protocol used for sharing files over the internet. There are several FTP server software packages available that you can download and use for free.