Suppose in a dataset, I have 3 tables, all has identical structure (column name and types), but different values. Lets call them A,B,C. Columnnames are (DepartmentID, DepartmentName, Parent):
These 3 table will create 3 bands, right? This is Table A:
This is table B: (child1)
This is table C: (Child2)
Relations are created based on parent's "DepertmentId" column and Child's "Parent" column for both cases. But when I've set the datasource for ultragrid, (this.uxStatisticWebGrid.DatasetAsDataSource=.....) only 2 bands are shown. Parent band and the band that is available in the first relation (table A with table B). If I remove the first relation, only then the 2nd relation is shown (table A with table C). Why dont 2 relation with (Table A) are shown in grid at the same time? Plz help on this.
I had the same problem - make sure that the [ViewType] property of the [DisplayLayout] object is set to [Heirachical]. It defaults to [Flat], in which case you only see the parent (top level) records.
HTH
Yes I tried that. I tried setting this before and after setting the datasource:
this.uxStatisticWebGrid.DisplayLayout.ViewType = Infragistics.WebUI.UltraWebGrid.ViewType.Hierarchical;
But my problem still exists. I am giving 2 screenshots of my problem:
Screen1:
Screen2:
As u see from the screens, there are 3 elements in Level 3: Akrew, Aristocrat, and ZtG. When going from level 3 to level 4, I've applied 2 relation. 1 with Akrew (DepartmentId=11), and the other with ZtG (DepartmentId=5) (Please check the table screenshots.).When I use both relations, it shows as in screen1. When I remove the first relation, it shows screen 2. Or if I create relation with ZtG before Akrew, then it shows as in screen 2. I could not bring 2 or more (+) signs at the same time for same level. Akrew, and ZtG should be expandable at the same time. But I couldnt do that. This is my problem. Plz help me on this now.