Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping Custom Groups 2

Status
Not open for further replies.

RedZero

Programmer
May 24, 2005
3
US
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


 
Just group by your mentioned formula and put subtotals for the number of files in the groupfooter.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top