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