This is a migrated thread and some comments may be shown as answers.

Set Number format on Values from SQL Server

1 Answer 38 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
hamish
Top achievements
Rank 1
hamish asked on 09 Jul 2014, 07:47 PM
I am using the RadPivotGrid with a SQL Server Analysis server (2014) and all appears to work as expected. However one issue I noticed is that any fields I select to appear as "values" - i.e. the 'facts' - I do not get the option to set the number format. For example when I select a field from a PivotFieldList that is bound to a collection I get the options Sum, Count, Average, Number format etc when I click on the down arrow of any fields in the "Values" section of the field List,

However when I select a field from a field list that uses a SQL Server Analysis Cube as the data source I only get the options Index, % of Grand Total, More Calculations and clear calculations. There is no option to set the number format - how do I achieve this?  - thanks

1 Answer, 1 is accepted

Sort by
0
Rosen Vladimirov
Telerik team
answered on 10 Jul 2014, 10:01 AM
Hello Hamish,

When the data is from OLAP Cube, it is expected to be formatted in the correct way, that's why RadPivotGrid doesn't have built-in functionality to set the number format for this scenario. However you can use CellTemplate in order to achieve this. I've prepared a sample project to demonstrate this approach. Please give it a try and inform us in case you have any problems or concerns.

Regards,
Rosen Vladimirov
Telerik
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
Tags
PivotGrid
Asked by
hamish
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
Share this question
or