data window grouping

[nspagnuolo]

i'd like to find out how many levels of grouping there are in a report through powerscript. i'm trying something around the lines of:

dw_report.describe('datawindow.Table.levels')

or

dw_report.describe('datawindow.Table.groups')

but of course, these don't work. what is the correct syntax? is this even possible??

thanks in advance,

nick

 

[tabhijit]

nspagnuolo,

Try FindGroupChange function. Keep increamenting level argument somewhere the function will return 0 or -ve number. That is the maximum level of grouping.

Regards,
Abhijit.