Set Number format on Values from SQL Server

2 posts, 0 answers
  1. hamish
    hamish avatar
    44 posts
    Member since:
    Jun 2007

    Posted 09 Jul 2014 Link to this post

    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
  2. Rosen Vladimirov
    Rosen Vladimirov avatar
    640 posts

    Posted 10 Jul 2014 Link to this post

    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.

    Rosen Vladimirov
    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.
Back to Top