Cyclic Group in Dimension

[jduenyas]

Hi all

I have a chart with a cyclic group as a dimension. The cyclic group consists of 4 fields, A, B, C, D.

I also have a report that contains the chart.

For an automation process that will print the report I created a script in VB which selects some fields (Year, Month, Sales Reps) prior to printing and I wish to select one of the cyclic fields (example 'C') so the chart shows the correct view.

Can that be done via VB code?

Any help is appreciated

Thanks

Josh

[jduenyas]

Actually I found the solution:

groups=ActiveDocument.GetGroups

groups(0).Cycle 1

(Group number is an ordinal number in your groupg collection and Cycle 'n' is the ordinal number of fileds in the group.

REmeber that the numbering is zero based)