I have a difficult situation and I'm not even sure it's able to be solved on here but I'll give it a shot.
I have a datawindow that is Dynamically created on each run. It could be grouped by any number of columns and it could contain any number of computation values. The detail band values are hidden and only the Header and Trailer values are displayed when the report is run. I need to loop through the groups, get the header and trailer values and write each line to an array so I can go through it later to write to Excel Cells.
Right now what I'm having to do is use FindGroupChange() for each group and get the Header Value of the group(for each group), then the trailer values. This is very difficult because everything is dynamic. Although I can get the # of groups and the row of their break. If this is the only way to do it I can provide an example of the datawindow I'm dealing with.
Or is there some way I can export this to Excel and Hide the detail rows and have excel show it the way it's shown when the datawindow is run(i.e just shows header and trailer values but no detail).