Expand/Collapse show Group & Sub Group Headings

 

In Report control I have  Main Group and sub Groups.

 

Normally if you Expand All it shows All Records Including Sub Group Records.

 

What I want is Expand only group Headings only (Summary only,No Need to Show Records).

 

It's a waste of time if you have 100's of group and sub group inside,Clicking manually one by one group to see sub group Headings summary

 

Is that Possible? If so How? Please help

 

 

If you use CollapseAll it will Collapse All rows and will show only Group Summary(Subgroups Hidden, you have to Expand group summary byclick

so that you can view Sub group summary)

 

But what I want is I want to view Group Summay + Subgroups Summary+ Subgroups Summary+...etc visible when I call Collapse All method

 

Instead of CollapseAll, I want CollapseGroups...!

 

How to do this? Any Idea?

 

 

  

 

Of course built in functions are easier to use in your own code  But what about next level (or next and next and next...) 

 

But there's more to it than above code to work. What about if .Populate is called? All rows will be expanded !!! So you need to call your function when the Report needs to be redrawn (adding record, sorting etc etc) The thing that we really need is an option to prevent the rows from expanding when .Populate is called. When adding records it easy to set Expanded to false within same function...

 

I also have a report with events (thousands and thousands) and when grouping is applied I don't want the main group to be expanded whenever an event is added (I have to call .Populate otherwise the record doesn't show) so I created an array which holds the value of expanded grouprow (true or false) maybe because user expanded row in meantime to have a look at the childs of the main group. So I have to store expanded value somewhere.

 

Well, glad there are some members willing to discuss this a little further

  

 

I'm not 100% sure for Parent/child records (because I don't use them) but for grouped records it expands them everytime. I expect it does the same in your case. Well try it yourself, just call populate after you collapsed some parents. As you replied in one post... the developer is lazy... Well in this case I recommend you use grouping and don't have to add code (maybe a few lines to set .Caption for grouprow, GroupPriority and SortPriority for sorting) to organize parent/child grouping.