Reporting help

pramn · yesterday

Hi Team ,

we have 1 demand and every demand we have assigned to 1 Project and 1 project we have several Project task .

Can t we have in one line all task front of related project? I mean its leading to more then one column .

do we have any solution for this ?

Bhuvan · yesterday

It is not possible out of box and best way to handle this would be to group by on Parent field so that it shows all related tasks under it. Project to Project task is 1 to Many relation and expected behavior is number of rows would be equal to number of project tasks.

If you want to have everything in 1 record [1 project : 1 consolidated project tasks], you can create a field with string data type and create a BR to glide record and store list of project tasks assigned to project in the field and display the information in report or dashboard. If that is your intention, you do not need database view tables in the first place and can be achieved by adding a new field and perform above mentioned logic.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

View solution in original post

Bhuvan · yesterday

@pramn

It is not possible out of box and best way to handle this would be to group by on Parent field so that it shows all related tasks under it. Project to Project task is 1 to Many relation and expected behavior is number of rows would be equal to number of project tasks.

If you want to have everything in 1 record [1 project : 1 consolidated project tasks], you can create a field with string data type and create a BR to glide record and store list of project tasks assigned to project in the field and display the information in report or dashboard. If that is your intention, you do not need database view tables in the first place and can be achieved by adding a new field and perform above mentioned logic.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan