We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Pivot Grid Control Features

Thread ID:





117359 Oct 3,2014 01:26 PM UTC Oct 7,2014 10:23 AM UTC WinForms 1
Tags: PivotGridControl
Mitch Miller
Asked On October 3, 2014 01:26 PM UTC

I am looking for a Windows Forms Pivot Grid Control to analyze data. I am trying to test out the Syncfusion control but have some trouble even finding out how to add the Pivot Field List or some sort of schema designer.

How do I add this? It's not in the toolbox.

Also how do I set a LINQ query result as the data source for the grid?

And does the grid support saving/loading of layouts?

Neelakandan Kannan [Syncfusion]
Replied On October 7, 2014 10:23 AM UTC

Hi Miller,


Thank you for your interest in Syncfusion products.



how to add the Pivot Field List or some sort of schema designer?

If you want to show the Pivot Field List in the Pivot grid control, you can enable the ShowPivotTableFieldList as True.


Please refer the below code:

this.pivotGridControl1.ShowPivotTableFieldList = true;


Please refer the below UG link:




How do I add this?


how do I set a LINQ query result?

You can set pivotGrid datasource from SQL query by converting Sql database to data table. so that we can easily assign the data source to the pivot grid. we have to use the System.Data.SqlServerCe.dll assembly to run this sample. We have also attached the dll in the below sample link. We have used a sample database file named “NorthWind.sdf”.


Please refer the below code:

this.pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName = "City", TotalHeader = "Total" });


this.pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName = "Last Name", TotalHeader = "Total" });


// Adding PivotColumns to the Control


this.pivotGridControl1.PivotColumns.Add(new PivotItem { FieldMappingName = "Country", TotalHeader = "Total" });


// Adding PivotCalculations to the Control


this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Extension", Format = "C", SummaryType = SummaryType.DoubleTotalSum });




public DataTable GetsData()


SqlCeConnection con = new SqlCeConnection("Data Source = SQLCeDB\\Northwind.sdf; Password = Hebot15v");


SqlCeDataAdapter adp = new SqlCeDataAdapter("SELECT \n\t[Employees].[Employee ID]\n\t,[Employees].[Last Name]\n\t,[Employees].[First Name]\n\t,[Employees].[Title]\n\t,[Employees].[Birth Date]\n\t,[Employees].[Hire Date]\n\t,[Employees].[Address]\n\t,[Employees].[City]\n\t,[Employees].[Region]\n\t,[Employees].[Postal Code]\n\t,[Employees].[Country]\n\t,[Employees].[Home Phone]\n\t,[Employees].[Extension]\n\t,[Employees].[Photo]\n\t,[Employees].[Notes]\n\t,[Employees].[Reports To]\n FROM \n\t[Employees]", con);

DataTable dt = new DataTable();


return dt;



Please refer the below sample:




Does the grid support saving/loading of layouts?

Currently, we don’t have support for saving the layout of pivot grid. We have filed a separate feature report for this task. This feature will be implemented in any of our upcoming releases. If you want further information about this, Please create a DT incident for your query so that we can update the feature related information.


You can create the DT incident from the following link.




Please let me know if you have any concerns.





This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon