User Tools

Site Tools


reports:notes

General Reports Notes

Miscellaneous Notes

  • When looking at a list of reports, make sure to change “Limit output to” to “All” or else you won’t see all of them.
  • Reports only pull information out, they do not change any information on the server.
  • There may be multiple ways to find the same information.
  • Two reports that look similar may not give you the same results depending on how the report templates are built.
  • A 'Count' provides a number, a 'List' provides detailed information.
  • When you find a report you like, clone it to your own folder so you can find it again (sort of like saving a bookmark).
  • Circulation numbers do not exist in the database prior to September 2006
  • There is a data difference between NULL and blank (blank once had something there, NULL was always empty).
  • There is a data difference between no price and price of $0.00.
  • If you find a report that gives you too much information, it is generally a better idea to filter down the results in Excel rather than recreating the report with additional filters.

Notable Shared Folders in the Evergreen Reports Module

  • csharp > csharp-shared - Report templates created in response to Help Desk Requests
  • ddale > Helpdesk Request - Report templates created in response to Help Desk Requests
  • ddale > Previous Year End Reports - Report templates created to run the PINES annual reports, but can be re-run for different time periods if needed
  • elainehardy - Specialized cataloging reports
  • PINESacqadmin - Specialized acquisitions reports
  • QRADMIN > Simple Reporting Tool - Report templates used by PINES Quick Reports
  • terran > Help Desk - Report templates created in response to Help Desk Requests
reports/notes.txt · Last modified: 2019/03/29 14:41 by tmccanna