Master Class

Essential Reporting Knowledge

Formula List


The ‘Formula List’ report can be used to generate a report that lists the steps that go towards making up a formula. This type of report can be configured to include things such as costs and submix composition.

Report Setup

This report can be found under the ‘Lists’ header in the Jasper Reports suite, and if we select it we will see the following options for running it.


Here we can filter by batch or product formulas, and/or select our desired formula from the drop down menu under ‘From Formula’. If we just want to view the report for just one formula, then the same formula must also be selected in the select the ‘To Formula’ column. We can also select another formula from the ‘To Formula’ column, and we will get a report for all of the formulas between, and including, the 2 formulas we have selected. Each report will have its own page.

We can also leave these blank and, depending on whether we have batch or product (or both) formulas selected at the top, we will get reports for all formulas of these types.

Once we have selected our desired formulas, we can choose to exclude any cost calculations, show any submixes, whether we want to see the expanded view of these submixes, and if we want to see the electronic signatures of who approved the formula for production.

Sample Report

If we run the report as we have set it up in the image above, we will generate one that looks like this:


Links To

Clicking on the commodities used in formulas will generate a ‘Used In’ report for that particular commodity.

Was this page helpful?