Task reports to show program custom field info? | Community
Skip to main content
L
Leah28850075mvkt
Level 5
February 12, 2021
Solved

Task reports to show program custom field info?

  • February 12, 2021
  • 2 replies
  • 681 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by imgrund

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.

2 replies

T
TealeMcCleaf
Level 6
February 12, 2021

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

    imgrund
    Adobe Employee
    imgrundAdobe EmployeeAccepted solution
    Adobe Employee
    February 12, 2021

    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.

      L
      Leah28850075mvktAuthor
      Level 5
      February 15, 2021

      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!

      Terms & ConditionsAccessibility statement

      Loading footer...