>If you want a group break in a report to sometimes group on Field1 and sometimes on Field2, you can do it by setting up your data properly and having a field designed solely for controlling the breaks. However, I was playing around with using EVAL(GrpExpr) as the "Group on" expression. GrpExpr would be set to "FIELD1" or "FIELD2" or whatever the field name is. That worked fine, it seemed, but I was also wanting to have it not group at all sometimes. I noticed if I used (GrpExpr) for the "Group on", it would be ignored and no group breaks would be in the report (using &GrpExpr caused an error). So I'm trying to determine how to get the best of both worlds: dynamic group breaks and, optionally, no breaks at all. Anyone have any experience with this?
>
>Thanks,
>
>Russell Campbell

See if this thread Re: Dynamic Grouping Thread #959120 can help and Re: Dynamic Page breaks Thread #690895.

See also Best Way to Remove or Suppress Optional Groups Thread #1009893