is there any sample code for binding an arbitrary collection of objects to the pivot grid. For example, I dont want to go through RIA to connect to the server, I just want to report on a collection of data I have. The following code does not work:
public
class Data
{
public DateTime Date { get; set; }
public string Ticker {get;set;}
public double Value { get; set; }
}
List
<Data> data = new List<Data>();
data.Add(
new Data{
Date =
DateTime.Parse("1/1/2000"),
Ticker =
"IBM",
Value = 1.0
});
this.xamPivotGrid1.DataSource = data;
It wants an instance of IOlapViewModel
Thanks in advance
Hi, thanks for the post. Am a beginner with Netadvantage infragistics. I have been trying to get myself acquainted with the xampivotgrid control. I have used the above code in a project and I have put code for assigning the datasource to the pivotgrid in a click event of a button. however, when i run the project nothin happens. is there something am missing?
basically what am trying to do is have a simple datasource from which i can display the data in the contol, say even a mysql database. i have gone through the documentation on the help site but it doesnot give much detail. any help will be greatly appreciated. thanks in advance
This works fine. Thank you. If I want to display 100000 of records then how about the performance. How to do pagination?
Hi,
The FlatDataSource class is in InfragisticsSL4.Olap.FlatData.v10.2.dll
Todor
HiI wasn't able to find the dll for using FlatDataSource. Where can i fint it?Thanks
Measures are created over measurable data only – this means that only properties with type of int, double and etc. are used when measure dimensions are generated.
You can create hierarchical structure over Pane.Geography property with second level based on Pane.Product property and that I think will produce the view you want.
HierarchyDescriptor<Pane> ds = new HierarchyDescriptor<Pane>(p => p.Geography);
ds.AddLevel(p => p.Geography, "Geography");
ds.AddLevel(p => p.Product, "Product");
flatDataSource.AddHierarchyDescriptor(ds);
pivotGrid.AllowCompactLayout = true;
pivotGrid.DataSource = flatDataSource;
Regards.
Plamen.