[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

Change a Group Field

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?
0
Clif
Asked:
Clif
  • 3
  • 3
1 Solution
 
mlmccCommented:
You can try this.

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

mlmcc
0
 
ClifAuthor Commented:
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)
0
 
mlmccCommented:
You did something wrong then.

You can also try it this way

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

mlmcc
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ClifAuthor Commented:
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.

0
 
mlmccCommented:
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

mlmcc
GroupOptions.jpg
0
 
ClifAuthor Commented:
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).
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now