We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Formatting columns in server mode.

Thread ID:





127265 Nov 7,2016 03:01 PM UTC Nov 8,2016 09:07 AM UTC ASP.NET MVC 1
Tags: PivotGrid
Nate Greene
Asked On November 7, 2016 03:01 PM UTC

Hey Guys,

I am using the PivotGrid control in a project I am working on. I have not been able to find the documentation on how to format the results that are being displayed from the OLAP cube.  Because I am also using the PivotTable Field List there is no way of knowing what fields the user will select and I cannot individually format each column based on type. 

Can I format all numeric results to place a comma to mark every 1000th? So that numbers like 999999 or 999999.00 would be formatted to look like 999,999 and 999,999.00 ?

Any help will be greatly appreciated.



Sastha Prathap Selvamoorthy [Syncfusion]
Replied On November 8, 2016 09:07 AM UTC

Hi Nate, 
We would like to inform you that we don’t manually format the values at control level. We would display the values in appropriate format which is set at the Cube itself. So we kindly recommend you to set the format for the measure values in the OLAP Cube level itself so that we would display the same in our control in the same pattern.   
Sastha Prathap S. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon