TUG-Libraries 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

Circulation Exceptions Report

Report Reference #

circ-200411-118

Revision Date

2011-05-19

Requestor

Alex McCulloch

 

Impromptu File Name

Directory

Catalogue Name

Circulation_Exceptions_Report2.imr

C:\Impromptu Web Reports\Circ_transactions

C:\Impromptu Web Reports\Circ_Transactions\ Circ_Transactions.cat

 

Web File Name ( login)

Web News Box

Circulation_Exceptions_Report2 (see sample)

TUG Reports and Cubes/Circulation User Services

 

Report Description:

This report lists transactions exceptions for the specified exception types and happening location. The report contains hyperlinks to sub-reports for detailed information on item charge/renew or patron. Some transactions exceptions do not have patron information or item information included because it is not available in the underlying table. If you create a custom view of the report in another newsbox the hyperlinks to the detailed information drill through reports will not work unless you also create custom views of the drill through reports in the same newsbox. The drill through reports are hidden and are called "drill_charge_info" and "patron_info_drill". See Important Notes below.

Prompt

Type

Description

Choose location codes that start with

Type in

Enter the start characters of the location codes to display
Select exception location(s) to include

Picklist

Select the locations to include in the report
Select exception(s) to include

Picklist

Select the exception types to include in the report

 

Filters:

Sort Order:

Data Elements:

Important Notes:

The transactions exception table is cleared after the Voyager overnight canned reports batch job. This report must run before the batch job to extract the day's transaction exceptions.

Schedule this job to run before 2:00 am.

If there is a problem with the Cognos server and the report does not run it is possible to retrieve the data from the server using TRELLIS Reporter module. The appropriate "crcrprts" file should be renamed to "crcrprts.print_location.inp" on the server. After the file has been renamed use TRELLIS Reporter module to print Circulation Reports.

The report uses sub-reports and should not be saved in delimited text or excel format.

Estimated run time:

5 minutes

Report Developer:

Gail Sperling