Could you please elaborate a bit more on your scenario? What do you try to achieve – a grid which looks like a pivot table where database columns are presented as rows (reverse order - vertical grid)
or pure pivot table
where the control generates a report based on the database data?
In the first scenario you can use RadGrid controls as is described in the help topic above. Also you can use custom paging
in order to execute operations on the database server.
If you try to achieve the second scenario– pure pivot table you need to use ASP.NET RadPivotGrid
component. The Kendo PivotGrid does not support paging or filtering when it is bound to source different than a cube.
Looking forward for your reply.
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.