Master Class

Essential Reporting Knowledge

Formula Report

Summary

The Formula Report lists formula definitions, their steps and their calculated costs for a selected formula range. Each formula shows its description, version, default size, minimum and maximum products, and last editor.

Use the display options to include submix details and optional-step costs, or hide cost and tolerance columns. The example shows a fictional finished product and its component blend.

Report Setup

Select the first and last formula in the range. This example uses DEMO-CAP-060 for both selections.

Choose whether to show submixes and include primary optional steps in the totals.

Choose whether to exclude costs or tolerances, then run the report.

Example input controls, reconstructed from the report parameters. Installed labels, choices and defaults may differ.Click the image to enlarge.

Sample Report

The example below uses fictional records populated into the report’s Jasper layout. Demonstration labels have been added; the content and number of pages depend on your data and selected options.

The report contains:

  • Formula details — Code, description, version, editor, default size, and minimum and maximum product quantities.
  • Formula steps — Step type, commodity code and description, target quantity and unit of measure, with optional steps identified.
  • Costs and tolerances — Step unit cost, step cost, formula total and cost per unit, plus lower and upper tolerances when enabled.
  • Submix details — Nested formula groups appear when Show Submix is selected.

This report does not include links to other reports.

Report example

Scroll to read the image. Press Esc to close.

Was this page helpful?
YesNo