Task reports to show program custom field info?

[ljanz]

I'm hoping to create a task report that can group some Program level custom form information. Here's what I have but nothing comes up:

group.0.linkedname=project

group.0.name=Project Topic

group.0.notime=false

group.0.valuefield=project:program:Project Topic

group.0.valueformat=string

textmode=true

Project Topic is the name of the custom form field I'm trying to display.

Any help? Is this doable?

[TealeMcCleaf]

Hi Leah,

Looks like you just need to add DE: in front of the Project Topic field to indicate it's a custom field. Also, as a side note you can't group on a multi-select drop-down field. Maybe you already know but throwing it out there just in case.

I hope this helps,

Teale

[AnthonyIm · Accepted solution]

Hi - I think you might have run into two issue. One is the format is not just string when you have custom form data. Also, I have no idea what notime=false is. LOL!

Try

textmode=true

group.0.name=

group.0.valuefield=project:program:Project Topic

group.0.valueformat=customDataLabelsAsString

Something I have done in the past that might also help... if I'm looking for Program info, I'll create a project report and select the field I want from the program in the grouping. I will then go into the text mode, copy it, paste it in the new report and then just add project: before the program. That way the valueformat is correct and, like Teale said, it will let you know if that field is even a groupable field.

[ljanz]

I don't know what that is either - I took it from something else - LOL!

What you shared worked!! Thank you thank you thank you!