Grouping items within a group

[Parabolic33]

Hello,

To clear up the version off the bat, I am using Crystal Reports 10.

I am writing a report which looks at sales based on certain accounts in my ERP system. I have set my selection criteria to only pull the items in a certain customer number range, and set the customer number as a group. THe trouble I am having is that we sell several product lines and each customer may have multiple customer numbers. For example, I will have customer number 0001020ch, 0001020BL, and 0001020kc, each represents the same customer, but for different product lines. What I want to do, is have the group list 0001020ch, 0001020bl, and 0001020kc as say 0001020 based on the left 7 digits in the customer number giving the sales for all three customer numbers as one.

If anyone can tell me if this is even possible, and if so how to accomplish it I'll greatly appreciate it.

Thank you,
Mike

 

[lbass]

Create the following formula and then insert a group on it:

left({table.customerno},7)

Then you can right click on the sales figure in the detail section and insert a summary at the group level. You can then suppress the detail section if you wish, and drag the summary into the group header.

-LB