This is a migrated thread and some comments may be shown as answers.
Pivot table and column formatting
2 Answers 24 Views
This is a migrated thread and some comments may be shown as answers.
Michael
Top achievements
Rank 1
Michael asked on 17 Aug 2010, 01:49 PM
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

2 Answers, 1 is accepted

Sort by
0
Michael
Top achievements
Rank 1
answered on 18 Aug 2010, 01:57 PM
Anyone have any ideas on this?
0
Pavlina
Telerik team
answered on 20 Aug 2010, 07:33 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Grid
Asked by
Michael
Top achievements
Rank 1
Answers by
Michael
Top achievements
Rank 1
Pavlina
Telerik team
Share this question
or