Cathy and Michelle --

Use the AS clause for the various grouping names rather than their field names, such as Group1, Group2, Group3.

Design the report using the Group1..3 names.

In your preprocessing of SQL for each invocation, assign the desired grouping fields to the Group1..3 names:

*1 invocation
SELECT State AS Group1, SalesRange AS Group2, ServiceRange AS Group3...

*2 invocation
SELECT ServiceRange AS Group1, State AS Group2, SalesRange AS Group3...

etc.

and modify as needed.

Jay




>Is the only thing different about the reports the expression in the data groups? Give me a little more information and maybe I can help you figure out how to use the one report you have instead of making three. It's worth a shot :-)
>
>Cathy
>
>
>
>>Hmmm... I could scan through our FoxTalk's, but it sounds like making 3 reports will be easier than switching the groups. :)
>>
>>Thanks for the info,
>>
>>Michelle
>>
>>>You're right ... you won't find a field or code or anything that tells it which band an object belongs to. What it does is look at the position (VPOS) of the object and then does a calculation to figure out which band that would fall into. It gets sticky, though, because you can't just take the height of each band .. you also have to add in a "fudge factor" for each band because it also counts the height of the gray bar that separates each band when you're in the Report Designer. I don't have the figure off the top of my head, but John Koziol wrote an excellant article in FoxTalk a while back that gives the "magic" number. I don't know if it's available on the Pinnacle website or not, but you can try.
>>>
>>>Cathy