Skip to main content
OCLC Support

Step by step: Count by gender

Learn how to get a count by gender in Amlib OpenReports.

Skills outlined in this Sample are revising those used last time

  • Use of the Count Function within a Data Field for a simple count
  • No Filter
  • Right aligning figures
  • Gaining Subtotals and Totals

A site may wish to get a break-down of counts of Males and Females and those Patrons where the Field is still empty. This could be shown as Counts in a Table or as a Graph

  1. Access the Report Designer TAB
  2. Select New from the buttons
  3. The Edit Report Window will display
  4. Enter a Report Title in the Report Title section. For the sample “Gender of Patrons
  5. Enter a Group since we want to find it later easily – for example Borrower
  6. Enter a Sub Group – for example Count
  7. Choose Report Type from the Drop-down options (Table is default):
    • Table – set out in rows and columns (select for the sample)
  8. Select Orientation
    • Portrait (Landscape would work too
  9. Leave Sql as is
  10. Show details: For this sample Report enter
    • None: As a straight Count is required
  11. Show Sub totals: Tick this to get the Subtotals
  12. Show total: Tick this to get the Grand Total
  13. Tick Private: leave this unticked but is your choice
  14. Show header on first page: For our sample tick this one if required
  15. Show header on next pages: This is your choice. But for now leave this unticked

Display Fields

  1. Select the Borrower Entity
  2. Select Borrower Barcode Data Field from the Entity as every borrower will have a Barcode so it will ensure a Count of every borrower. Drag and drop to Display – as this is an uncomplicated report we can set the Count directly for this Field
  3. Select the Borrower Barcode Data Field
  4. Change the Function to Count (this will ensure the number of Barcodes are counted rather than the sum of the Barcodes)
  5. Change the Align to Right (this will ensure the numbers align right so they sit correctly in the listing
  6. Change the Header if required. For example No of Borrowers so it makes sense of the Count when it is displayed

Group Fields

Drag and drop Borrower Gender to the Group fields to split the report into the Gender codes used by your Library


If ALL borrowers are to be counted, split by Gender, there is no need to set a Filter!

Order by

Sometimes it is useful to have an Order sequence if the way it orders the report by Default is not how it should display. For example,

  1. Drag and drop Borrower Gender to the Order by section
  2. Leave as Default (Ascending)


Select Preview to view the Report


Once the Report is successful, select Save to be available in the Report Viewer