Pivot Grid Dynamic Column Names

[Hüseyin Cenk Özmutlu]

Hi. I am working on a topic for a job and I want to know that how can I use syncfusion pivot grid with dynamic column names according to sql query?

[Sastha Prathap Selvamoorthy]

Hi Hüseyin, 

We are unable to get your exact requirement. So, please let us know whether you want to bind Relational/OLAP/DataTable(data retrieve from SQL database) data. Meanwhile, we think that your requirement is related to bind data items(fields) dynamically in rows/columns/values to display it in PivotGrid control. If so, you can able to add row/column/value fields dynamically by using Field List, please check our online demo link below for your reference. 

 

Online Sample: http://asp.syncfusion.com/demos/web/pivotgrid/userinteractions.aspx 

 

Also, we have provided detailed information in our online document link below. 

 

Online Document: https://help.syncfusion.com/aspnet/pivotgrid/relational-pivottable-field-list  

https://help.syncfusion.com/aspnet/pivotgrid/olap-field-list  

Please let us know if you have any concern. 

Regards, 

Sastha Prathap S.