Hi all! I've been using this code within project reports to show whomever is assigned as a designer in a project:
displayname=Designer
linkedname=direct
listdelimiter=
listmethod=nested(projectUsers).lists
textmode=true
type=iterate
valueexpression=IF(CONTAINS("Designer",{user}.{role}.{name}),{user}.{name})
valueformat=string
Now, this is pretty crescent fresh and it does a good job. My question: Is there a way to sort this data? Ultimately, I'd love to group the Designer names or sort by using "sortOrder=1/sortType=asc", but this doesn't work for this field. Also, how would I go about creating a grouping from this information? Sorry if this is a noob question, but I'm still kind of a noob. :D Thanks for your help! John J. O'Sullivan GAF