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

Select New from the buttons of the Report Designer
The Edit Report Window will display
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”
Enter a Group if the Reports for example Stockitem
Enter a Sub Group for example Counts
Choose Report Type from the Drop-down options (Table is default):
- Table – set out in rows and columns (select for the sample)
Select Orientation
- Landscape (does not matter as it will just show a simple Count)
Show Sql Leave Sql as is
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
Show Sub totals if a calculation based on Groups is required (Default is unticked). For the sample untick this
Show total if a Total calculation of the Sub totals is required (Default is unticked). For the sample tick this
Tick Private For our sample leave this unticked.
Show header on first page. For our sample leave this unticked
Show header on next pages. For our sample leave this unticked

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

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

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

An Order is not necessary as it is just a count

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