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
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