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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Setting formats

Thread ID:

Created:

Updated:

Platform:

Replies:

123663 Apr 7,2016 11:02 AM UTC May 4,2016 12:43 PM UTC ASP.NET Web Forms 7
loading
Tags: PivotGrid
Jorge Pampin
Asked On April 7, 2016 11:02 AM UTC

Hello,

How to set the values format (included number of decimal) to the fields in the "Choose fields to add to report" setion of the PivotSchemaDesigner?

Thanks!

Ramesh Govindaraj [Syncfusion]
Replied On April 8, 2016 12:49 PM UTC

Hi Jorge,


Thank you for using Syncfusion products.


We have prepared a sample with the fields having decimal values. Please find the sample in the following link.


Sample Link:http://www.syncfusion.com/downloads/support/directtrac/123663/ze/PivotFieldList2032720248


Regards,
Ramesh G.


Jorge Pampin
Replied On April 11, 2016 07:40 AM UTC

Hello,

In that sample any value has  a numeric format. I need to konw if you have this PivotGrid:

 <ej:PivotGrid ID="PivotGrid1" Url="" runat="server" ClientIDMode="Static">
        <DataSource>
            <Rows>
                <ej:Field FieldName="Country001" FieldCaption="Country001"></ej:Field>
                <ej:Field FieldName="State" FieldCaption="State"></ej:Field>
            </Rows>
            <Columns>
                <ej:Field FieldName="0002" FieldCaption="0002"></ej:Field>
            </Columns>
            <Values>
               <ej:Field FieldName="Quantity" FieldCaption="Quantity"></ej:Field>
            </Values>
            <Filters>
                <ej:Field FieldName="Date" FieldCaption="Date"></ej:Field>
            </Filters>
        </DataSource>
        <ClientSideEvents Load="onLoad"  RenderSuccess="loadSchemaDesigner"/>
    </ej:PivotGrid>

If you add the amount field from the PivotSchemaDesigner, how to set the currency format?

Thanks!

Sastha Prathap Selvamoorthy [Syncfusion]
Replied On April 12, 2016 01:48 PM UTC

Hi Jorge,

We would like to inform you that number format for the value fields could be set during initialization of control in the dataSource.  It could be maintained until the field is removed from the report.  We have created a simple sample for setting number format during initialization.  Please find the sample in the following link.
Sample link: http://www.syncfusion.com/downloads/support/forum/123663/ze/PivotFieldList-777806730

Meanwhile, we have logged an improvement task for maintaining the format also on removal and re-addition.  Please find the task for the same in below link.
Task link: http://www.syncfusion.com/support/directtrac/features/JS-28821

Please let us know if you have any concern.
Regards,
Sastha Prathap S.

Jorge Pampin
Replied On April 12, 2016 03:39 PM UTC

Hello,

How to set the "es-ES" culture to the sample (to show the symbol € and the ',' as decimal separator), becouse this doesn't work:

<ej:PivotGrid ID="PivotGrid1" Url="" runat="server" ClientIDMode="Static"  Locale="es-ES" >

Thanks!


Ramesh Govindaraj [Syncfusion]
Replied On April 13, 2016 10:46 AM UTC

Hi Jorge,

We have created an incident to log an issue report on behalf of you. Our support engineer will assist you through incident. We request you to follow with the incident for further details.
 
https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents 

 

Regards,
Ramesh G.




Jorge Pampin
Replied On May 4, 2016 10:31 AM UTC

Hi Jorge,

We would like to inform you that number format for the value fields could be set during initialization of control in the dataSource.  It could be maintained until the field is removed from the report.  We have created a simple sample for setting number format during initialization.  Please find the sample in the following link.
Sample link: http://www.syncfusion.com/downloads/support/forum/123663/ze/PivotFieldList-777806730

Meanwhile, we have logged an improvement task for maintaining the format also on removal and re-addition.  Please find the task for the same in below link.
Task link: http://www.syncfusion.com/support/directtrac/features/JS-28821

Please let us know if you have any concern.
Regards,
Sastha Prathap S.

Hello,

I cannot find the task, when will this feature be developed?

Thanks!

Ramesh Govindaraj [Syncfusion]
Replied On May 4, 2016 12:43 PM UTC

Hi Jorge, 
Yes, we have completed the improvement task and included in our Syncfusion Essential Studio 2016 Volume 1 Service Pack release v14.1.0.46. Please find the following link to download the latest version of Essential Studio. 
We have included a new event BeforePivotEnginePopulate and this event fires every time when the PivotEngine populates. Please find the sample below which illustrates the usage of the event for maintaining the format also on removal and re-addition. 
NOTE: Kindly use the above sample after installing the new version v14.1.0.46  . 
Regards,
Ramesh G.
 


CONFIRMATION

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.

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

;