We help IT Professionals succeed at work.

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

MikeM670
MikeM670 asked
on
107 Views
Last Modified: 2018-10-15
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
Comment
Watch Question

Professor Emeritus of MIS at Penn State Erie and Owner, Millet Software
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Ido meant to create a formula in the formula editor then group on the formula.

mlmcc

Author

Commented:
Thanks to both of you.  Ido for the exact solution needed and mlmcc for clarifying some confusion.  Works as advertised.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.