Group on Formula

[EscapeUK]

I have a basic report.

However i want to customise the grouping for example.

Group 1 Contains Customer_Id's 1,5,7,11,15

Group 2 Contains Customer_id's 2,77,3,6

Group 3 Contains Customer_id's 8.10,14,55

Group 4 Contains all the others

Any ideas how to do this.

 

[vidru]

Create your formula like the following, then group on it:

//@GroupFormula
If {Table.Customer_ID} in [1,5,7,11,15] then
"Group1"
Else If {Table.Customer_ID} in [2,77,3,6] then
"Group2"
Else If {Table.Customer_ID} in [8,10,14,55] then
"Group3"
Else
"Group4"

-dave

 

[bdreed35]

Another option would be to use the grouping options in Group Expert.

You can define the Group name, and then the condition the data needs to meet in order to qualify for that named group.

It will accomplish the same thing as vidru's solution, just another option.

~Brian