Pivot table and column formatting

[Michael]

I have a grid in which I'm using the pivot layout.  Since the pivot layout uses autogenerated columns, is there any way to format the columns data.  I have mixed text and numeric data returning and I would like to format the numbers (ie ###,###,###,##0).  Is there anyway to do this?  I'm using SQL SERVER as my backend DB and from what I know there isn't any easy way to format the numbers on the backside. 

Thanks

Mike

[Michael]

Anyone have any ideas on this?

[Pavlina]

Hi Michael,

You can customize the properties of auto-generated columns at runtime by providing a handler for the grid's ColumnCreated event. In the event handler, cast the column to the appropriate type and set its attributes. You can review this help article (Auto-generated columns section) for more information.

All the best,
Pavlina
the Telerik team