Skip to main content
M
MichaelPe1
Level 5
July 21, 2021
Question

How can I customize a grouping label in a report based on what the result is?

  • July 21, 2021
  • 1 reply
  • 527 views

I have a report that is grouped by Project Priority. In the report only I would like the row that has the group name to be custom. For instance right now they are grouped by Red Alert and High. But I would like to make those say something like "Red Alert - First Priority" and High would equal "Due Today". How can I accomplish this?

Also is there any way to edit the color of the group header rows to make them more noticeable?

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

    1 reply

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    July 22, 2021

    Hi Tracy, Try this... (Note: I did this for a task or issue report since you said Project Priority. If this is for a project report, just remove the {project}. that I have put in)

    group.0.name=

    group.0.valueexpression=IF({project}.{priority}="4","Red Alert - First Priority",IF({project}.{priority}="3","Due Today",IF({project}.{priority}="2","When You Can Get To It",IF({project}.{priority}="1","Low Priority","No Project Priority Given"))))

    group.0.valueformat=HTML

    textmode=true

      M
      MichaelPe1Author
      Level 5
      July 22, 2021

      This worked perfectly, Thank you.

      Terms & ConditionsAccessibility statement

      Loading footer...