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

Display Fields

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

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

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