Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Template report : h...
 
Notifications
Clear all

Template report : how to show activities data ?

6 Posts
2 Users
0 Reactions
899 Views
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 
[#9956]

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,


 
Posted : 03 Oct 2025 19H16
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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.


 
Posted : 04 Oct 2025 21H10
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

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,


 
Posted : 06 Oct 2025 11H26
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

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,


 
Posted : 06 Oct 2025 12H13
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

link_Activity will list activities linked to item.
You will have same fields as for link.


 
Posted : 08 Oct 2025 1H32
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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)


 
Posted : 08 Oct 2025 1H36
Share:

Scroll to Top