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

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 the project’s name in the Next Due Activities report?

Merlin delivers a template for “Next Due Activities” report which is based in XSLT. When editing this report template in order to get the value of the “project” for a task, you will see that it is not very easy to browse up the related xml node and locate the name of the parent project. To work around this issue, we simply modified the “classic report” python report to output the desired information.  You may download  it from here. An output sample: 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 V

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 role for your resources?

You may download and use a report template we just created. Here 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

Merlin – Do a bit of magic in reports – part III

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 list overdue tasks along with the next activities, in “Next Due Activities” report?

The ‘Next Due Activities’ report lists not yet completed activities ending today or within the time period defined in the report’s options. This is done by a ‘select’ in the Report.xslt file:

<xsl:for-each select="(//Activity | //Project) [not(Activity) and xs:dateTime(expectedEndDate) &lt;= xs:dateTime($maxDate) and xs:dateTime(expectedEndDate) &gt;= $now and actualCompletion &lt; 1.0]">

If you would like to list over due tasks as well you would need to modify the select not to check if the expected End Date is greater than the current time point… thus: Continue reading