Sorting issue with a custom column on a report.

[Jared_Mauch]

Workfront Community,

A report that uses a custom column to show the program name linked to projects isn't fully sorting like I had hoped. It's sorts programs sporadically. For example, Program A with be listed six times in a row, then Program B and Program C will each have some entries, and then Program A will show up again with more entries. I can't group off of this custom column in the groupings settings for the report, but am I able to edit the text mode that will allow all of Program A's entries to be listed together?

displayname=Program
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=program:name
querysort=project:program:name
sortOrder=1
sortType=asc
textmode=true
valuefield=project:program:name
valueformat=HTML

[Kurt_Jones]

Jared, this looks like a project report?  In the groupings area you should be able to find Program Name as a choice to use for grouping which should put all the various programs together. 

[Jared_Mauch]

Kurt, it's actually a task report for finding tasks assigned to a user via a prompt. Program Name is column option that I can add to the report, but it is blank for all the entries when I add it. That's why the custom column was created. Is there something I can add to the text mode for the column to have entries grouped correctly by it?

[skyehansen]

I see it's happening in my instance as well, which makes me feel like it's either a bug or intentional.

* To confirm, you can report it to Support and ask. 

* Workaround 1: you could sort it by program ID rather than program name. This should have a better result (keep the program stuff together) although it definitely won't go in alphabetical order by program name, at this point.

* Workaround 2: put a custom field on the project custom form to bring the program name down a level, so you're sorting at a closer level.