Setting formats

[Jorge Pampin]

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]

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]

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]

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]

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]

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]

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]

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. 

http://www.syncfusion.com/forums/123963/essential-studio-2016-volume-1-service-pack-release-v14-1-0-46-available-for-download  

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. 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/155225/PIVOTF~3430964391.ZIP 

NOTE: Kindly use the above sample after installing the new version v14.1.0.46  . 

Regards,
Ramesh G.