Skip to main content
OCLC Support

Stockitem entity

Learn about the Stockitem entity in Amlib OpenReports.

Average cost of item by stats code 

Skills outlined in this Sample – Getting Averages, Setting format to $ 0.00

  1. Select New from the buttons of the Report Designer
  2. The Edit Report Window will display
  3. Enter a Report Title in the Report Title section. This can display at the top of the report. For the sample we can give a Title of Average cost of item by Stats Code
  4. Enter a Group if the Reports for example Stockitem
  5. Enter a Sub Group for example Average Cost for items
  6. Choose Report Type from the Drop-down options (Table is default):
    • Table – set out in rows and columns (select for the sample)
  7. Select Orientation
    • Landscape (select for the sample)
  8. Leave Show Sql
  9. Show details: For this sample Report we will leave as the Defaults
    • None: Shows the numbers for the results but not the details within the Report. Fields will be hidden
  10. Show Sub totals if a calculation based on Groups is required (Default is unticked). For the sample tick this
  11. Show total if a Total calculation of the Sub totals is required (Default is unticked). For the sample tick this
  12. Private For our sample leave this unticked.
  13. Show header on first page. For our sample leave this ticked
  14. Show header on next pages. For our sample leave this unticked

Display Fields

  1. Highlight the Entity from the Entities / Data Fields Column
  2. For this sample, select the entity of Stockitem
  3. Drag and drop Item Cost into the Display Field Table
  4. Click on the Item Cost to set the Format to $ 0.00 (ensure a space is inserted after the $ symbol)
  5. Change the Function to Avg.
  6. Check that the Align is Right. Alter the Heading to Average Cost per Item to make more sense of the report and change the Width to cater for the longer Heading

Group

  1. Highlight the Stockitem Entity from the Entities/Data fields column
  2. Drag and drop Item Stats Code to the Group fields column which will base the Average on Item Stats Code

Filter

It is not necessary to select a Filter at all if you want to display the average of All Stats codes returned as a result

NOTE: A Filter can be defined if only certain Stats codes are required or an extra element is to be included – for example, only certain Locations, certain Form Codes, set a Date Received to get an Average of new resources, those that have a certain Process code like Missing in Stocktake etc.

Order by

It is not necessary to display an Order unless a specific Order is required

Preview

Select Preview to view the Report

Save

Once the Report is successful, save so it can be used again in the Viewer or Designer