Merge two grouping in Task Report

[Kundanism]

Hi,

Any idea/ tip for text mode, how to merge two groups to visible in one. Created a task report and tried to do 

by using standard fields but no success.

Adding screen shot for reference. Please feel free to ask any other inputs.

Best regards,

Kundan.

[Richard_Le_ · Accepted solution]

Hi Kundan,

Try the below text mode for your grouping.

group.0.linkedname=parent
group.0.namekey=view.relatedcolumn
group.0.namekeyargkey.0=parent
group.0.namekeyargkey.1=name
group.0.valueexpression=CONCAT({parent}.{referenceNumber}," - ",{parent}.{name})
group.0.valuefield=parent:name
group.0.valueformat=HTML
textmode=true

Best Regards,

Rich.

[Kundanism]

Thanks a lot @Richard_Le_, genius . Just one more query, what to do if I want to filter both merged grouping with respect to planned completion date. Could you please recommed any tip or should need to update the above text mode? Please reply.

Have a nice day!

Mvh

Kundan.

[Richard_Le_]

Hi Kundan,

No problem. I'm not sure I understand your question. A filter is independent of the grouping. Any filter applied to the planned completion date will not affect the parent task name or reference number.

Please clarify and I'll do my best to help.

Best Regards,

Rich.