HI Team,
i am very new to infragistics control and now i have to work using ultrawingrid controls.
please help to get a sample to get this below output.
basically i just wanted to show data in a hierarchical label using ultrawingrid and each parent should calculate sum of child values.
below i just provided a sample to table, which will help you to understand my requirement.
Jan-16
Feb 16
Mar 16
Apr 16
May 16..So on for 10 years
+ Export(total)
8
16
1
4
+ Country
+ City
+District 1
3
12
13
0
May 16..So on
Production1
Production2
2
11
+District 2
5
+ Import(total)
14
32
+District
9
10
Please let me know if need more clarificatio0n.
Thanks
Ramesh
22
33
44
23
Production3
20
15
35
Hi Ramesh,
You can accomplish this using the CellDataRequested event to load data on-demand. See the following article for a code sample:http://help.infragistics.com/doc/WinForms/2015.2/CLR4.0/?page=WinDataSource_Load_Data_on_Demand.html
Please let me know if you have any questions.
Hi
i want to bind the band from database or from list based on band selection.
ex: if user clicks on +Country(USA0) , all the city will be populated which is under USA.
same like click on any city , all the districts will be populated based on city
i have attached the sample program which will give you clear idea about my requirement.
i have added some record manually using for loop and loading in page load. but i don't want to load all the record(becaz there are huge number of data and it's very slow)
, only i want to load all country in page load and once +(country) is selected then all the cities under country will populated. same as city. clicking on city, all district under city will it populated. so that i can make the performance faster.
it's really very urgent , i want to show huge number of data(dynamically) in hierarchical structure , not getting any idea how can i achieve this.
Please provide if you have any other sample or if possible please modify thus sample.
let me know if you need more clarification.
You can accomplish this with a CalcManager and the following formulas:
e.Layout.Bands[0].Columns[0].Formula = "sum([Band 1/Column 0])";e.Layout.Bands[1].Columns[0].Formula = "sum([Band 2/Column 0])";
I've attached a sample to demonstrate this. Please let me know if you have any questions.