Skip to main content
OCLC Support

Step by step: simple count of items

Learn how to get a count of items in Amlib OpenReports.

Skills outlined in this Sample:

    • Getting Item Totals only
    • Getting Totals and Subtotals
    • Using a Display Field and a Group Field
    • Changing the format to be a Count
  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 “All Items
  4. Enter a Group if the Reports for example Stockitem
  5. Enter a Sub Group for example Counts
  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 (does not matter as it will just show a simple Count)
  8. Show Sql Leave Sql as is
  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 untick this
  11. Show total if a Total calculation of the Sub totals is required (Default is unticked). For the sample tick this
  12. Tick Private For our sample leave this unticked.
  13. Show header on first page. For our sample leave this unticked
  14. Show header on next pages. For our sample leave this unticked

Display Fields

  1. Highlight the Entity from the Entities / Data Fields
  2. For this sample, select the entity of Stockitem
  3. Drag and drop Item Barcode into the Display Field Table, which will Count the Nos of Barcodes
  4. Select on the Item Barcode to make the Function Count

Group

Unless the Count is to be grouped in some way leave this blank

Filter

Unless the Count is to be filtered in some way leave this blank

Order by

An Order is not necessary as it is just a count

Preview

  1. Select Preview to view the Report

Save

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

  • Try breaking down this report by simply grouping by Stats code or Form Code

Tip: Ensure that you have Subtotals AND Totals ticked in the Show Details section to get the break-down totals

  • Try filtering by an element to get more targeted results – for example use the Calendar to get only new items, or filtering it be only local Stock (Item Barcode begins with AL or what may be appropriate), or filtering it to get only a certain Item Process like Missing
  • There are countless possibilities…..start Saving a list that can be used again and again