Icon

Reporting with BIRT

<p><strong>Reporting with BIRT</strong></p><p>In this workflow we prepare data to be displayed in a report.</p><p>Starting from the accounting of a list of projects, on one branch we calculate the money in budget for each year for each one of the project and on the other branch we calculate the money actually spent for each project each year. We then export the prepared data and build a report with the KNIME Report Designer (BIRT) extension within KNIME.</p><p>Note. We still support BIRT in the classic interface, however, since BIRT is no longer maintained we recommend using the nodes of the KNIME Reporting extension instead.</p>

URL: KNIME Beginner's Luck (Book Homepage) https://www.knime.com/knimepress/beginners-luck

Workflow: Reporting with BIRT


In this workflow we prepare data to be displayed in a report.

Starting from the accounting of a list of projects, on one branch we calculate the money in budget for each year for each one of the project and on the other branch we calculate the money actually spent for each project each year. We then export the prepared data and build a report with the KNIME Report Designer (BIRT) extension within KNIME.

Note. We still support BIRT in the classic interface, however, since BIRT is no longer maintained we recommend using the nodes of the KNIME Reporting extension instead.

Calculating money spent for each project each year

Calculating money in budget for each project each year

Reading data

Calculating remaining money for each year

Send prepared data to BIRT

Send prepared data to BIRT

Calculating money for each project and year

Money by project and by year
GroupBy
Renaming "<year>+Sum(...)" into just "used <year>"
Column Renamer
Money assigned to project each year
Pivot
Money chart
Data to Report (BIRT)
Inner joinon RowIDs
Joiner
Renaming "<year>+Sum(...)" into just "assigned <year>"
Column Renamer
Money used byproject each year
Pivot
Projects.txt
CSV Reader
money table
Data to Report (BIRT)
Calculate remainingmoney for each year
Expression

Nodes

Extensions

Links