Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)