Grouping Custom Groups 2

[RedZero]

I have a report that needs to be gouped by company but the companies have branches that show up as companies. i've made a formula to label the branches the name of the company


if {trCustomer.description} startswith "CHALLENGE" then "CHALLENGE" else
if {trCustomer.description} startswith "ACCESS" then "ACCESS E" else
if {trCustomer.description} startswith "STOCKTON TURNER" then "STOCKTON TURNER" else
{trCustomer.description}


but when I preview the report each branch just has the name I set in the formula

company Files
challenge 5
challenge 6
challenge 8
challenge 1
challenge 50
ACCESS E 10
STOCKTON TURNER 20
ACCESS E 15
STOCKTON TURNER 65
challenge 10
challenge 5
challenge 6
ACCESS E 6




How can I combine the branches to one group.

company Files
ACCESS E 31
STOCKTON TURNER 85
challenge 91

So that I can then run totals on thier total company files.

Running CRXI MSSQL2000

Thank's in advance Guys

 

[JeroenBoon]

Just group by your mentioned formula and put subtotals for the number of files in the groupfooter.

 

[lbass]

I agree with JeroenBoon--it looks like you used the formula for the groupname instead of inserting a group on it. So try inserting a group on it, insert the summaries on the detail field, and then suppress the detail section and drag the (new) groupname into the group footer.

-LB