grouping by region question 1

[ChipF]

I need a group or formula that will group specific regions together so I can do calcuations on them, I want all Texas regions to appear in this group "West TX, Metro TX, Border, Greater TX" and the other group can have any other regions that shows up on the report. How do you do this kind of grouping? I know you need to insert a group and use a formula as group name, but from there I am lost. This is what I want: sts_org_region to be one of "West TX, Metro TX, Border, Greater TX" in this group.

Any help is appreciated.

Chip

 

[bdreed35]

1. In Design, Right Click the appropriate Group Header and select "Change Group"
2. In the 2nd drop down box from the top, change to "in specified order."
3. Under the Specified Order tab, create a named Group called "Texas" or whatever you want to call it, but this is what will show up on your report.
4. Set up your criteria for you group (is one of "West Texas", "Border", etc.) then click OK
5. Under Others tab, choose how you want to deal with the other values.

Now you should be able to do your calculations.

 

[ChipF]

worked like a charm, thank you bdreed35