?
Solved

Change a Group Field

Posted on 2011-03-23
6
Medium Priority
?
292 Views
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?
0
Comment
Question by:Clif
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 35198435
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
 
LVL 10

Author Comment

by:Clif
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)
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35199126
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
LVL 10

Author Comment

by:Clif
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.

0
 
LVL 101

Expert Comment

by:mlmcc
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

mlmcc
GroupOptions.jpg
0
 
LVL 10

Author Closing Comment

by:Clif
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).
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Course of the Month10 days, 11 hours left to enroll

764 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