Irwsoft Web Control

PivotTable
Brief Information
DescriptionA data summarization control found in data visualization programs such as spreadsheets or business intelligence software.
Features
  • Filter/search,
  • Freeze columns,
  • Dynamic column function change,
  • Paging, and
  • Sigma values calculation (sum, max, min, average, std, stdP, var and varP).
  • Supports image preview and/or file downloading for Image/File data-type.
PivotTable
PivotTable control


The PivotTable control is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. The control supports column/field function and calculation change dynamically in run-time. The control has very friendly column/field function change with drag/drop, radio button selection and arrows.


Example : Displays data sumarization of Order with PivotTable


C# code for Person table

// 1) Sample code for Person table
public class Person
{
     // 2) The columns of Person table.
     public int ID { get; set;}
     public string Product { get; set;}
     public string Category { get; set;}
     public string ImageUrl { get; set;}
     public string Type { get; set;}
     public DateTime DateOfBirth { get; set;}
     public double Amount { get; set;}
     public double Discount { get; set;}
     public string Country { get; set;}
     public string Rate { get; set;}
}

ASPX code for PivotTable

// 1) Defines the PivotTable control
<irw:PivotTable ID="PVT1" runat="server" SkinStyle="DarkBlue" RowLabels="Category,Country,Product" ColumnLabels="Date,ID" SigmaValues="Amount"
     Height="500" Width="1000" AllowFiltering="true">
     // 2) Defines the properties need to display inside Header tag
     <irw:PivotTableColumn Name="ID" DataType="Integer" />
     <irw:PivotTableColumn Name="Product" />
     <irw:PivotTableColumn Name="Category" />
     <irw:PivotTableColumn Name="Date" DataType="Date"/>
     <irw:PivotTableColumn Name="Country" />
     <irw:PivotTableColumn Name="Amount" DataType="Money" />
</irw:PivotTable>


Related Topics :


Irwsoft Data Ultimate Edition 4.0 supports data-schema extension (entity framework, linq to sql, simple class, and etc).