Titles by use, fund and date range

Staff Web StaffWeb: UG | UW | WLU
Libraries: UG | UW | WLU
Campus: UG | UW | WLU

Home TUG Statistics & Reports

Documents Contacts Search

Impromptu Report Documentation

Search Reports Status Database

Report Title	Titles Used <: #
Report Reference #	col-200105-76
Revision Date	2011-05-19
Requestor	IRMC (uw)

Impromptu File Name	Directory	Catalogue Name
Title_use_by_fund.imr Title_use_by_fund2.imr	c:\Impromptu Web Reports\Acquisitions	c:\Impromptu Web Reports\Acquisitions\Acquisitions-serials.cat

Web File Name ( login)	Web News Box
title_use_by_fund (see sample) title_use_by_fund2 (see sample	TUG Reports and Cubes/Acquisitions/Fund Reports

Report Description:

This report will list titles for items that have use less than the value entered in the prompt if the item was created in the date range entered in the prompt and there is an order for the fund(s) selected in the prompt.

Prompt	Type	Description
List ledgers that start with:	Type in	Enter institution initials (e.g. UW, UG, WLU) or the ledger name to select funds from (e.g. UW Approval)
Select a ledger	Picklist	Select the ledger that contains the funds you want to report on
Select one or more funds	Picklist	Select the funds for the titles to be included on the report (use the <Ctrl> or <Shift> keys to select multiples)
Include location codes that start with (e.g. UG):	Type in	Enter the institution initials or the location code to include in the report
Select items that were used < ?	Type in	Enter the use threshold for the report (to select items with 0 use enter "1")
Enter Start date (yyyy-mm-dd)	Type in	Enter the start date of the date range for items to be included in the report
Enter end date (yyyy-mm-dd)	Type in	Enter the end date of the date range for items to be included in the report

Filters:

Item create date between start date and end date enter in prompts

Item location code starts with string entered in 2nd Institution identifier prompt

Fund name equals fund names selected in the prompt

Item historical circulations less than number entered in last prompt

Sort Order:

Fund name (ascending)

Call number (ascending)

Data Elements:

Call number
Title
Total historical circulation use
Item location name
Charge Date (for "title_use_by_fund2" only)

Important Notes:

It is important to note that items on the report with 0 use could in fact be currently charged out. The "title_use_by_fund2" report will indicate this.

Estimated run time:

< 10 minutes

Report Developer:

Gail Sperling