>>>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>
>Thanks, Naomi. The first two did not help, but the third one did. It was kind of a strange thread. The guy asked the question, someone gave a response, then the guy basically said "I did that" but did not indicate if it worked. So I used the suggestion and, indeed, it does work, with a few adjustments. Thanks again.
Glad it worked for you.
If it's not broken, fix it until it is.
My Blog