Combining groups in CR8.5 1

[simmolinho]

Hi there,

In my group header I have a formula field. Is it possible to combine 2 of the results under one group header. eg if I have 10 results under group 'a' and 5 under group 'b' can I combine them to make group 'c' with 15 records??

Thanks for your time

 

[MColeman]

Maybe if you group on a field that is a concatenation of both groupnames.

 

[simmolinho]

Thanks for that.

How would I go about doing it?

 

[MColeman]

For example, if groupname1 is formula1
and groupname2 is formula2,
create a new field formula12 as

trim(totext(formula1)) & trim(totext(formula2))

Create a new group based on the new formula12 field.