I need to fix a several rows of data that belongs to a group (please see image . The area bounded in red is the one I need fixed). The outlook Group by header is not visible. We need this group fixed to show summary info at all times for all the details below sort of like Excel's freeze panes. My problem is I get the top row frozen but the rows under its hierarchy does not. Is it even possible to do this using UltraGrid? Any suggestions on how to to this?
Hi,
I don't think it is possible to fix child rows. But if you want to display a summary, you would add a Summary to the band and fix the summary row on top of the grid.
Another option would be to use a RowScrollRegion. By dragging the splitter bar on the grid's Vertical scroll bar you can create two scroll regions. This isn't exactly what you want, because the same row will be visible in the bottom scroll region as well as the top one. Also, it won't be easy to position the size of the region to exactly fit the GroupByRow and all it's child rows. But it's pretty close to what you want to do here.
Can I display the summary in hierarchical fashion like the image I posted? I do not think the RowScrollRegion will work for me.
IsraelTan said:Can I display the summary in hierarchical fashion like the image I posted?
No, not really. You might be able to achieve something like this using a whole bunch of summaries, but it's probably too complex to be worth the effort.
What about using a second grid control?
Mike,
Do you know if there is a pending feature request to have a fixed group row functionality in the UltraGrid? I have everything working except that one.
Thanks,
Israel
Hello,
I was following Mike’s suggestion and I am using two grids in order to achieve something similar to your requirements, I also synchronized horizontal scrolling of both grids. Please run the sample an let me know if this work for you.
Thank you.
There are no plans I know of to implement Fixed GroupByRows in the immediate future.
Synchronizing the scrolling of the two grids is not too tough, but you would also need to synchronize other things, like the colmun size and position.
If you are allowing the user to change the Groupings, then that would make things more complicated, as well.
But I don't see any better alternative.
I think I can live with this solution. Hristo sent out a sample code to sync scrolling. I'll do the sync of column resize. Then I need to figure out the height of the whole group on the top grid so I can resize both grids accordingly.
Thanks for following up and giving suggestions!