User Specified Grouping
 

Hello All,

Currently I'm got a report working that has column groupings
pre-defined in the code. The users wants to be able to define their
own column groupings manually while working on the sheet itself and
have said groups stay each time the report is re-ran. Do to the way
the report was designed I need someway to test what groups exist on the
columns in the worksheet and to re-apply those same groups after the
report has been ran.

This normally wouldn't be a problem except the code generating (and
formatting) the data wipes all the groups out each time the report is
processed. I can't change this functionality do to the report being
linked to an OLAP application (TM1).

Any help is greatly appreciated.