Is there a way to list Project field on a Task report but only have it show in the first task that is not complete?

Question

We have a field on our Projects named Brief Status and Summary.

I have a task report that groups by Project and I would like to add that note field to it, but when I do it repeats that information for every task. I'm trying to streamline this to only display necessary information so having this repeat causes clutter. Is there a way in text mode to tell it to only display if its the first task that is not complete in the project? Or any other limiting information that would restrict it to one task but would always display on this report?

What would really be awesome is if we could display information in the Grouping Row. So that row would say the project name - (the info in the Brief Status Summary field). A girl can dream!

Pretty sure the answer is no, but I thought I'd ask just in case.

ChloeRo · Accepted Answer

Tracy, I could be misunderstanding your request, but I think the grouping row information is possible. It would look like this:

group.0.valueexpression=CONCAT({project}.{name}," - (",{project}.{DE:Brief Status and Summary},")")

Not sure what happens if the Brief Status and Summary is lengthy though, it might cut it off at a certain point.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded