Grouping on part of a field

[ginaburg]

I am using Crystal 8.5.
I have a field called PACOSTCATID.
I want to group on part of that field as shown below.
PACOSTCATID
0100000010 this is used for budget $
0100000011 this is used for actual $
0100000012 this is used for actual $
0100000020 this is used for budget $
0100000021 this is used for actual $
0100000022 this is used for actual $

I want to group on the first 9 characters. For the above expample, I would have 2 groups 010000001 and 010000002.
I tried to put a formula on the group for
Left ({PA01301.PACOSTCATID}, 9)

In my report, I have a column for budget and one for actual. When I use this grouping, I get the following:

010000001 group heading
0100000010 50,000 budget amount

010000001 group heading
0100000011 1000 acutal amount
0100000011 1000 actual amount

how do I get one group heading with everyhting under it.

 

[synapsevampire]

Are you using other groupings?

Your formula looks fine, so you're probably leaving out important information, such as the fact that you have some other grouping.

BTW, I'd use:

val(Left({PA01301.PACOSTCATID}, 9))

-k

 

[MrBillSC]

Looks like you have PACOSTCATID as group 1 and your formula as group 2. If this is so, reverse them.

MrBill