Skip to main content
OCLC Support

Counter entity

Find information about the Counter entity in Amlib OpenReports.

Borrower memos by barcode 

The Counter can be used for any Entity to include a Count on the Group Field. In this sample, it will count the Number of Memos for each Barcode giving the name of the Borrower and the Number of Memos

  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 “Borrower Memos”
  4. Enter a Group if the Reports for example Borrower
  5. Enter a Sub Group for example Memos Count
  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
    • All: To display all the details
  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. Tick 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 Counter Entity from the Entities / Data Fields
  2. Drag and drop Group Details Count into the Display Field Column
  3. Highlight the Borrower Entity from the Entities / Data Fields
  4. In this sample we have Borrower Full Name - Given, Surname

Group

  1. Highlight the Borrower Entity from the Entities/Data fields column
  2. Drag and drop Borrower Barcode to the Group fields column which will base the Count on Memos per Barcode

Filter

  1. Select the Borrower Entity
  2. Drag and drop Borrower Memo Date to the Filter
  3. Select Greater than from the Drop-down Options
  4. Enter the required date from the Calendar Order by 

It is useful to have an Order sequence if required

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