Link to home
Start Free TrialLog in
Avatar of 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

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

Link to home
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


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.

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