Sorting Order of My Group 1

[goduke]

Guys, I have a group in my report called division_id that I am grouping on. I am customizing the name of the group by concatinating the leader's last name of that division and the division_id. What I want to do is have the group sort based on that customized name. I can't group on the leader's last name because I have some leaders that lead more than one division, and I would lose one of their divisions. I have totals based on division, so I have to show each one. Example code is below:

--What I have by grouping on division_id--
Mears (SD0010)
England (SD0015)
Harper (SD0021)
Mears (SD0034)
Davis (SD0048)

--What I want by still grouping on division_id--
Davis (SD0048)
England (SD0015)
Harper (SD0021)
Mears (SD0010)
Mears (SD0034)

I appreciate the help. Thanks.

CM

 

[kskid]

Create a formula

//@GroupID
{table.lastname} + {table.groupID}

Insert a group on @GroupID

 

[kskid]

To include the parenthesis

//@GroupID
{table.lastname} + " (" + {table.groupid} + ")"

 

[goduke]

Thanks kskid, that worked perfect.