Irwsoft NETCore Asp

PivotTable
Brief Information
DescriptionA data summarization tag-helper 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 tag-helper


The PivotTable tag-helper is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. The tag-helper supports column/field function and calculation change dynamically in run-time. The tag-helper 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 tag-helper
<PivotTable ID="PVT1" 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
     <PivotTableColumn Name="ID" DataType="Integer" />
     <PivotTableColumn Name="Product" />
     <PivotTableColumn Name="Category" />
     <PivotTableColumn Name="Date" DataType="Date"/>
     <PivotTableColumn Name="Country" />
     <PivotTableColumn Name="Amount" DataType="Money" />
</PivotTable>


Related Topics :


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