Those of you who have checked our new post series about “Merlin report templates” know by now…
- How to modify existing reports
- How to edit description or report template names
- How to create your own report templates
- How to localize a Merlin report template
- Further tips for localizing an xslt report template
- How to add an option in an xslt report template
- How to add an option in a python / wbl report template
- How to add a property into an existing xslt report
- How to add a property into an existing python /wbl report template
Now let’s do some magic with the reports.
- Map a status or flag information to a graphic file
- Define the size of the project image over the options
- List overdue tasks along with the next activities, in “Next Due Activities” report
- Report planned, actual and planned vs actual work per phase in a chart
- Report expected work costs per role for your resources
- Report expected work costs per resources’ group
- Report the project’s name in the Next Due Activities report
- Modify the “Milestone Trend Report” to show the WBS in the table and in the chart
- Report expected or actual resources’ work per phase
- Report resources work cost per phase
- Report cash flow for expected cost or approved budget
- Report billable costs entered on elements
- Report element costs by type
- Report issues
- Report Events
- Output Project’s WBS
- Resources Time allocation to various tasks and subtasks
- Calendar View
Calendar View
If you like to report  working days of your project’s scheduling and/or assigned resources, this is a custom report template to use.
You may check contained ‘CalendarView.py’, “CalendarView.wbl” to see how we iterate in project’s duration, convert dates to the desired formats and color the table on working days.
Feel free to modify this custom report further as you require for your needs.
Some output samples:
Showing project scheduling grouped by month.
Or resource’s working days grouped by week…
And the report options:
Installation:
- Extract the zip first
- place the contained mrept package under the following path of your mac: ~/Library/Application Support/Merlin/Reports
- (in case you have no “Reports†folder please create it first and pay attention to name it exactly as “Reportsâ€)
- restart your Merlin and
- call File > New Report… to find the new report called “Calendar View”.
Hello Vicky
I have tried to use the moveParentTitletoAsignmentsSubTitle script you pointed me towards in the user forum. I have managed to get it into the Merlin SendTo Menu in Merlin, but when I select the script nothing happens. Please advise?
Nik
Hello Nik,
your comment is not related to this post…
In the forum thread you can read how it works.
It writes for the top most project you’re keeping open the title of their parent activity in the subtitle column of assignments.
If you then switch to the utilization, enable the ‘subtitle’ as label for the Gantt elements, you will get the Gantt with the assignment titles.
So..
open the project you want to use the script with
start the script
enable the column ‘subtitle’ in the activities view,
expand all
when the script is done, it should have written the title of the parent activity in the ‘subtitle’ column of the assignments, so you can use the ‘subtitle’ column in the utilization view.
Best regards, Vicky