Link to home
Start Free TrialLog in
Avatar of MikeM670
MikeM670

asked on

How to group on field with one group containing more then one field being grouped by

Crystal Reports 2016

I am using the standard grouping by field in my report.  However I would like to actually combined several fields to fall under one specific group.  How would I go about doing that.

Field to group by.  A, B, C, D, E, F


Example:
                       Group: A
                           Detail A
                       Group B
                            Detail B
                       Group C
                            Detail C
                       Group (Contains D, E & F)
                            Detail D,E,f
ASKER CERTIFIED SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MikeM670
MikeM670

ASKER

I wrote a formula based on your example and applied it to the Change Group Options/Use a Formula as Group Sort Order.  I get an error of when saving the formula.
Ido meant to create a formula in the formula editor then group on the formula.

mlmcc
Thanks to both of you.  Ido for the exact solution needed and mlmcc for clarifying some confusion.  Works as advertised.