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