Reports Dialog

Create your own reports for your recipes and recipe groups.
The report system uses TAGS in a report template. These tags are replaced with data when the report is generated. A tag is a data item within <>. So for example <INGREDIENTS> is a tag that will be replaced by the correctly sorted ingredients in the recipe.

To the left is a tab control where you either select your current recipe or a set of recipe groups.
In the middle is the Nutrition information and the ingredient list and allergens. The ingredients are sorted by weight. If an ingredient contains sub-ingredients they are used else the name of the ingredient is used.

Add ins

If the recipe has Add ins they will show in this list. You can select if any or all of the add ins should be included in the report.

Settings

Settings specific for the reports. More info in the report settings dialog.

Info

Pressing info will show a list of the ingredients and the calculated percentage of each ingredient. This is useful to validate that the calculations are correct. It will also show a list of ingredients that are not validated for nutrient calculations.

Tags

When writing report templates using MSWORD for example you should use this dialog to copy the TAGS to the clipboard and insert them in the Word document. This is easier than typing in the tags manually and you remove the possibility of typing errors. You also get a preview of the value of each tag. More info in the report tags dialog.

Language

Here you can select the language the tags are translated to when generating the report. This is useful if you need to generate multiple reports in different languages using the same report template.

Reports

The list of report templates.

Add +

Add a new report. Opens the Add report dialog. You can create a new report or open a report from a file.

Delete –

Removes the report template

Edit …

Edit the report. If this is a DOCX report the template is opened in for example MSWORD. If it is a TPL (local editor) report it is opened in the local report editor. If you have support for DOCX files this is the preferred system to use as it has more possibilities and options compared to the local editor.

Open

If this checkbox is checked the report is opened after it is created. If it unchecked it is only generated and saved to disc. Having this unchecked can be useful for automation.

Run report

Generates the selected report.

Recipe groups

In the reports you can either make a report for the current recipe or you can make reports using a set of recipe groups RCPXs. Selecting the Recipe groups tab allows you to create a set of RCPXs and generate a combined report. All the ingredients and allergens will be combined and sorted and allows you to make one nutrition and ingredients label for the whole set of RCPXs.

At the top there is a Filter section you can use to setup subsets of RCPXs. Press the + button at the top to add a Filter. This is optional and by default there is a Filter called Default.

What you have to do first is add one or more RCPXs to the list. This is done with the + button in the lower left corner. This opens the RCPX database dialog and you can select RCPXs to add to the list. Then fill in the quantity or weight of each RCPX and the report is ready to be generated.

The Edit … button will open the RCPX dialog where you can edit the RCPX.

The Open button will open all sub-recipes in the RCPX in the main dialog.

And finally at the bottom there is a summary of quantity, weight and cost for the RCPXs.

Checkboxes

Only items with the checkbox checked and a Quantity>0 are included in the reports. Above the list you have a Check all and Uncheck all button.

Batch nr

Batch numbers are used for tracking and will remember the RCPXs and the quantity of each in a database. These batch numbers is saved in a database and can be opened. More info in the Batch nr dialog.

Example Report

Press the + button below the reports list.

Here we create a Word report and name is Sample.
When the report template is created Word will open and you can edit it and add the TAGS we like to use. In this example we will create a report with the list of ingredients and allergens and the recipe.
We start by going back to ICC and press the Tags button top open the TAGS dialog.

We double-click on <INGREDIENTS> to copy this TAG to the clipboard. Then we switch to the Word document and paste the TAG.

We continue to add the TAG <ALLERGY_CONTAIN> and we type some text to make it look nicer. We also create a table and fill in some nutrient information.

We save the document and close Word and switch back to ICC closing the Tags dialog.

We now press Run report to generate the report.

Some TAGS are multi-line tags and when placed in a table the table will auto expand with multiple rows of data. An example are the Ingredient TAGS staring with <I.
Here is an example of a report template with an expanding table.

And when generating this report it looks like this.

Adding the Chart as an image

You can add the current chart to a report. Insert an image in the Word document and name it CHART. Then the image will be replaced by the current chart.
The easiest way is to first right click on the chart and select Copy to clipboard.
Then open the reports and edit the report you want to insert the chart in.
Insert the image from the clipboard and select it.
Now select the Home Tab.
There should be a Select button, press this and select Selection pane.

Type in CHART.

Now you are done and when running the report the image will be replaced by an image of the current chart.
Example movie: