Change a Group Field

Posted on 2011-03-23
Last Modified: 2012-05-11
I got a report completed, but realized that I used the wrong field to group on (I should have grouped on Site Manager, but grouped on division manager.

Unfortunately I have lots of layout and formulae based on the group.  I tried just dropping the group and regrouping to the correct field, but that erased all my group layout and the formulae don't work any more.

Is there any way to change a group field without rebuilding the report?  How?
Question by:Clif
  • 3
  • 3
LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 35198435
You can try this.

Right click the group header or footer in the left margin
Change the field for the group.

LVL 10

Author Comment

ID: 35198997
Doing that only brings up a dialog that allows me to change the field the group is sorted on, but not the group field itself.

I should have mentioned in the OP that I'm susing Crystal XI (if that matters)
LVL 100

Expert Comment

ID: 35199126
You did something wrong then.

You can also try it this way

Select the group you need to change
Click OPTIONS button
Change the group with the dropdown.

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

LVL 10

Author Comment

ID: 35200736
It's awful hard to screw up right clicking on a massive grey area.

Once again, that changes the field the group is sorted on, not the group field itself.

LVL 100

Expert Comment

ID: 35201158
IN the picture below changing the field in the dropdown changes the field you are grouping on.

It doesn't change the field in the grouip header.  You will have to change that to show the group name or value.
I forgot to mention that and that may be the part that is confusing the issue

LVL 10

Author Closing Comment

ID: 35201491
You are right, and I need to take a vacation.  I'm skipping words as I read.

Thanks for the help (and for putting up with me).

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal Reports--SubReport 3 61
Crystal Reports Groups need Hand Cursor on Hover 4 80
Sum of multiple formulas 6 23
Dates formatted Differently on another pc 2 16
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question