CANNED REPORTS
Monitoring the collections
Items that have been borrowed [OPTIONS : any number of times / 0 times / 1 to 5 times / 6 to 10 times / 11 to 20 times / more than 20 times] in the last [OPTIONS : anytime / week / month / 3 months / 6 months / year / 2 years]
Set Limits :
Limit by branches : [OPTIONS : all branches / branch 1 / branch 2 / branch n]
Limit by accessibility : [OPTIONS : no limit / public shelves / stocks]
Limit by type of documents (note, multiple choice checkboxes : if no category ticked, takes everything) : [OPTIONS : books / cd-roms / audio cds / whatever]
Limit by localisation : [OPTIONS : any section / adult section / youth section / …]
Classification limit : from [TEXTFIELD] to [TEXTFIELD]. Note : (class numbers, truncated - blank if you don't want to set a classification limit)
Limit by category of patrons : [OPTIONS : any / Youth / adult / other] Note : i.e. rights granted for the different categories of patrons
Limit by other category of patrons : [OPTIONS : white collar / Blue collar / …] Note any category chosen by the library; in France, it's often something that has to do with the social class; could be ethnic origin or whatever.
Limit by age ranges of patrons : [OPTIONS : any / under 14 / 15-19 / 20-25 / 25-54 / 55+]
Limit by sex of patron : [OPTIONS : M / F / any]
Note : the system should be able to provide both for a raw number (result) and a list of items. As far as the list of items is concerned, it could be a good idea to provide for a standard display and also to provide for the librarian to set a list of fields if the standard display doesn't suit his (her) needs.
Standard display, I would suggest :
author
title
publication date
price
class number
bar code number
number of borrowings
Sort by : class number = default display?
The system should be able to export the list of items in CSV format, so as to allow the librarian to import it in Excel or any other spreadsheet.
Turnover
Set limits :
From date [TEXTFIELD YYYY/MM/DD] to date [TEXTFIELD YYYY/MM/DD]
Limit by branches : [OPTIONS : all branches / branch 1 / branch 2 / branch n]
Limit by accessibility : [OPTIONS : no limit / public shelves / stocks]
Limit by type of documents (note, multiple choice checkboxes : if no category ticked, takes everything) : [OPTIONS : books / cd-roms / audio cds / whatever]
Limit by localisation : [OPTIONS : any section / adult section / youth section / …]
Classification limit : from [TEXTFIELD] to [TEXTFIELD]. Note : (class numbers, truncated - blank if you don't want to set a classification limit)
Monitoring the public
Total number of patrons in the database; sort by [OPTIONS : categories of rights granted to patrons / other categories of patrons (e.g. ethnies] / age ranges of patrons / sex of patrons]
Average number of borrowings by patron in last 12 months.
Set limits:
Limit by category of patrons : [OPTIONS : any / Youth / adult / other] Note : i.e. rights granted for the different categories of patrons
Limit by other category of patrons : [OPTIONS : white collar / Blue collar / …] Note any category chosen by the library; in France, it's often something that has to do with the social class; could be ethnic origin or whatever.
Limit by age ranges of patrons : [OPTIONS : any / under 14 / 15-19 / 20-25 / 25-54 / 55+]
Limit by sex of patron : [OPTIONS : M / F / any]
Total number of active patrons (1 borrowing at least in the last 12 months); sort by [OPTIONS : categories of rights granted to patrons / other categories of patrons (e.g. ethnies] / age ranges of patrons / sex of patrons]
Average number of borrowings by active patron in last 12 months.
Set limits:
Limit by category of patrons : [OPTIONS : any / Youth / adult / other] Note : i.e. rights granted for the different categories of patrons
Limit by other category of patrons : [OPTIONS : white collar / Blue collar / …] Note any category chosen by the library; in France, it's often something that has to do with the social class; could be ethnic origin or whatever.
Limit by age ranges of patrons : [OPTIONS : any / under 14 / 15-19 / 20-25 / 25-54 / 55+]
Limit by sex of patron : [OPTIONS : M / F / any]
Total number of patrons newly registered in the last [OPTIONS : month / year]
Total number of patrons that re-registered in the last [OPTIONS : month / year]
Number of patrons sorted by geographical categories (for instance, in a public library : from different areas in the county, for a list of neighbouring counties, other)
Monitoring the back-office work
Acquisitions
Items bought in the last budget year :
Set limits :
Limit by branches : [OPTIONS : all branches / branch 1 / branch 2 / branch n]
Limit by type of documents (note, multiple choice checkboxes : if no category ticked, takes everything) : [OPTIONS : books / cd-roms / audio cds / whatever]
Limit by localisation : [OPTIONS : any section / adult section / youth section / …]
Classification limit : from [TEXTFIELD] to [TEXTFIELD]. Note : (class numbers, truncated - blank if you don't want to set a classification limit)
Pulping of documents during the last budget year:
Set limits :
Limit by branches : [OPTIONS : all branches / branch 1 / branch 2 / branch n]
Limit by type of documents (note, multiple choice checkboxes : if no category ticked, takes everything) : [OPTIONS : books / cd-roms / audio cds / whatever]
Limit by localisation : [OPTIONS : any section / adult section / youth section / …]
Classification limit : from [TEXTFIELD] to [TEXTFIELD]. Note : (class numbers, truncated - blank if you don't want to set a classification limit)
