I understand that these are mutually exclusive. My question is this:
1) Is there a way to fake it? To get the result of fixed row headers even though fixing columns isn't an option?
or alternatively
2) Is there a way to have two levels of groups without using GroupLayout?
I have a report where the headers need to be three deep, like this:
It's a simple hierarchy, with items in the first row containing items in the second row, which contain items in the third row. I'm only using GroupLayout because that's the only way I've found to achieve the above. But if there's a way I can do it without GroupLayout, so that I could freeze the first column (because this report gets very long horizontally), that would be just as good.
Hello Lisa,
Thank you for posting to Infragistics Community!
You are correct that by design the RowLayout mode and column fixing cannot work together. As you have probably already encountered, there are multiple forum threads, where the same question has been discussed.
Consequently, I am afraid that there would be no straightforward approach to achieving this, however, I have a simple workaround suggestion for you. The UltraGrid Band’s Groups and levels feature can be leveraged to achieve column grouping. Here can be found the dedicated page about Arranging Cells in our documentation. This arrangement can be created via the UltraGrid designer as well as from code, similar to the RowLayout.
However, this mode only allows one level of groups. From the screenshot, I can see that there is a topmost group in your grid, although I am not sure if it includes all second level groups. If that is the case, a kind of workaround can be to leverage the UltraGrid’s caption instead of a topmost group:
this.ultraGrid1.Text = "Instead of a top-level parent group"; this.ultraGrid1.DisplayLayout.CaptionVisible = Infragistics.Win.DefaultableBoolean.True; this.ultraGrid1.DisplayLayout.CaptionAppearance.FontData.Bold = Infragistics.Win.DefaultableBoolean.True;
Additionally, I am not sure, which “first” column you are referring to, however, please note that only column group headers can be fixed in this mode. In case your requirement involves fixing a single child column (for example “Actual” from the first col. Group – “Char [054]”), what can be done is to extract it in a separate group of its own that can be fixed.
Attached you will find a small sample demonstrating this suggestion. Please, test it on your side and If you require any further assistance on the matter, please let me know.
Best regards,Bozhidara PachilovaAssociate Software Developer
5280.UGGroupLayoutColumnFixing.zip
That's what I was afraid of. No, the top header in that screenshot does not contain all groups in the second row. In the particular report I was using, there were two top level groups, each of which has subsidiary groups, each of which has columns. I do use groups as you suggested for simpler reports. Unfortunately, that's not an option here.
Thanks... I'll take a look at that.
Hi Lisa,
Thank you for the quick reply. I understand that you are already familiar with Band Groups and that unfortunately they are not applicable to this particular grid’s layout because of the 3-levels deep hierarchy.
As a last resort option, I found this forum thread, where the same question is discussed and another workaround approach is suggested – displaying a separate grid, containing the column that has to be fixed next to the main one. There is also a small sample demonstrating this. It is far from ideal, however, if the grid is primarily for display purposes, it may do the job.
Best regards, Bozhidara Pachilova