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

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 billable costs entered on elements
Costs entered on elements may or may not be billable to your customers. This report may output such costs in a table.

So you need to get first all elements of a project. Following python method does so and excludes private elements.

Continue reading

Merlin – Do a bit of magic in reports – Part IX

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.


What if you want to report expected or actual resources’ work per phase?

We have used the report template as posted in this thread of Merlin’s user forum in Google.

Changed the methods asking for resource costs to ask for resource expected or actual work.

Continue reading

Merlin – Do a bit of magic in reports – Part VIII

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.


What if you want to modify the “Milestone Trend Report” to show the WBS in the table and in the chart?

Merlin delivers a template for “Milestone Trend Report” which is python based.

Quick and dirty approach:

When editing this report template in order to get the value of the “WBS” of the milestone in the table, you can simply enter the property “wbsCode” in the iteration for the milestones of the project in the wbl part of the report template:

To replace the chart labels of the x axis, you can off course simply modify the xTicks(self) method in the py part to ask for the wbsCode instead of the milestone title. That means

title = milestone.wbsCode().replace("\"", "\\\"") Continue reading 

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

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.


What if you want to report expected work costs per resources’ group?

We work similar to the previous question and output group costs instead.  So you may download and use a report template we just created. Here some an output sample: Continue reading

Merlin – Do a bit of magic in reports – Part IV

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.


What if you want to report planned, actual and planned vs actual work per phase in a chart?

You may download and use a report template we just created. Here some output samples:

Continue reading