>I've been looking at the .frx of a report that has 3 groups. I'd like to be able to programatically switch the groups around into a different order. It looks as though the records for the fields are in group order, but I can't see anything that distinguishes one group's fields from the next. Anyone have any insight?
>
>Thanks,
>
>Michelle

Hi 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