Clif
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
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.
Once again, that changes the field the group is sorted on, not the group field itself.
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
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
ASKER
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).
Thanks for the help (and for putting up with me).
ASKER
I should have mentioned in the OP that I'm susing Crystal XI (if that matters)