Hello,
i work on a template report for project and need to include a table with activities.
But using [link_Activity.ref1Name;block=tbs:row] for example lead to empty table (there is 2 activities on the project i use for test).
How to list activities (with name, start date and end date, progress, ...) ?
The only way i found is to make a template for activity and showing project's data.
But my need is to propose a template from project to list critical informations like next activity to end, activities with past due date, etc...
Regards,
You can list activities only for template on activities.
You cannot list activities on project template.
There would be a workaround, but not very light : as you can list linked items on template report, if you link the activities to the project, you'll be able to list them on project template.
But note that if you link Activities and risks, you'll list both, is no specific order.
Thanks for the answer.
But, in this case, what is the meaning of link_Activity (Lien) in available fields in template report for project ?
Reading this :
I understood that all type link have these values available, so link_Activity.ref1Name giving the name of the activity and so...
Am i in mystake ?
Regards,
I'm doing more tests and understand the link.
Only linked elements are visible in link.
So i think in will be great that every attached element (in database way, so element with link type one-to-many in database) where accessible.
So activities, expenses, milestone, risk, problem, ... will be accessible via template.
It will be a large amount of data for some project but we can make a real project bilan thru template report and not only a short view (except if we link every element but in will be a large job and you have to maintain links in addition to get your project up-to-date).
A possible evolution ?
Regards,
link_Activity will list activities linked to item.
You will have same fields as for link.
Extending to all items would be :
- complex : for instance for Project, we would need to look for any class with idProject, or Activity, we would need to look for any class with idActivity, ...
- not performant at all : in current template report, we get all data that can be used, even if it is not used in the template (we do not analyse the template)