Solved

Change a Group Field

Posted on 2011-03-23
6
285 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
  • 3
  • 3
6 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 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 100

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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
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 100

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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now