GROUPING GROUPS

[David3]

Hi @ll,
imagine a report with 3 groups:
GROUP1
Record1
Record2
GROUP2
Record3
Record4
GROUP3
Record5
Record6

I want to keep together GROUP1 and GROUP2, like this:
GROUP1 and GROUP2
Record1
Record2
Record3
Record4
GROUP3
Record5
Record6

Is this possible???

Thanks a lot,
David.

 

[dgillz]

Sure, create a fornula field:

If {YourField} = <<insert logic here for current groups 1 and 2>> then &quot;Group1&quot; else <<enter a sencond set of logic here>>

Then group by the formula field instead of the database field. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[ALAMM]

There is other option too.Place the below Data in GROUP HEAER 2 and suppress the GROUP 1.
GROUP1 and GROUP2
Record1
Record2
Record3
Record4

Then place this info in GROUP Header 3
GROUP3
Record5
Record6
NOTE: With the above option make sure to have &quot;New Page After&quot; in Group Footer 2. That will make sure you have correct Group names.

Good Luck