Tutorial No.1 - The Stock Report

This report is a fairly simple listing of stock items but it will takes you through quite a few features of Reportico. The tutorial is split into 4 stages and the finished report is already available in the dropdown reports menu.

Running the Stock Report

Before you try to work through this tutorial, try running the final report first. Select Stock Report from the Inventory dropdown menu on the tutorial report menu page (Alternatively you can point your browser at the URL


You should see the criteria entry screen for the Stock report. As it indicates, this is a simple report listing stocks levels in the Northwind database. Try a test run by pressing the HTML run button. A list of all the products in the database will appear grouped by category and showing stock levels.

Now experiment with PDF and CSV formats.

Also run the report with the Debug Mode list box set to “Low”. When you run the report, you will see the SQL statement used to fetch the data rather than the report output. This is a useful report debugging tool that provides more information about the report execution as you add more complexity. The debug option can be hidden from this screen for live deployment.

Finally try using the criteria entry options. Try using the magnifying glass expand keys to bring up the country list against the Country criteria, select one or two categories using the checkbox and trun the report. Only stock items from the selected categories are selected.

Overview of the Stock Report

In setting up this report, you will gain experience of the following :-

Stage 1. Creating a Basic Report

In this section you create a new report and enter a simple SQL query to select from the northwind tables. You will also learn a bit about labelling and formatting and how to set the report title and description.

Stage 2. Creating Report Entry Criteria

In this section you learn how to add report selection criteria and database lookups in the form of list boxes and checkboxes. You also learn how to make one criteria lookup dependent on another.

Stage 3. Working with expressions using assignments

You create additional reporting values based on the data returned from our query. You learn how to work with rolling minimum, maximum, sum and average values. You also learn how to incorporate assignments into criteria lookup displays

Stage 4. Working with Groups

You learn to print group headers and trailers. You also learn how to create group expressions such as group sums and group averages

  • northwind_tutorial_1_-_the_stock_report.txt
  • Last modified: 2018/05/04 21:40
  • (external edit)