Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dynamic data grouping
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01364749
Message ID:
01364767
Views:
11
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform