MERLIN – DO A BIT OF MAGIC IN REPORTS – PART XI

Those of you who have checked our new post series about “Merlin report templates” know by now…

Now let’s do some magic with the reports.


Report cash flow for expected cost or approved budget
We have used snippets from the ‘cost distribution’ report template as basis.

In a Python method we collect all tasks with group and sub-tasks.

In the WBL we iterate in this array and output the desired values

Getting the task number is easy, you need to ask its flatOrder. ‘title’ and ‘expectedCost’ bring the total costs of each item. The method spaceByLevel places a space before the item’s title for indentation purposes. It calculates as 15px per level. Continue reading