Grouping in Numeric and Currency Columns

[Amit Saraf]

I have added GridNumericColumn & GridCurrencyColumn in SfDataGrid Control Binding them to decimal data type of column in datatable

I want to show values grouped as 1,23,45,678.00 but values are show as 12345678.00 

How to achive this

Thanks in advance

[Sivakumar R]

Hi Amit,

You can achieve your requirement by setting GridNumericColumn.NumberGroupSizes  and GridCurrencyColum.CurrencyGroupSizes properties. Find the code snippet below,

<Syncfusion:GridNumericColumn NumberGroupSeparator="," MappingName="EmployeeSalary">

    <Syncfusion:GridNumericColumn.NumberGroupSizes>

        <Int32Collection>3,2,2,0</Int32Collection>

    </Syncfusion:GridNumericColumn.NumberGroupSizes>
</Syncfusion:GridNumericColumn>

Documentation:
https://help.syncfusion.com/wpf/sfdatagrid/column-types#gridcurrencycolumn
https://help.syncfusion.com/wpf/sfdatagrid/column-types#gridnumericcolumn

Refer below msdn link to understand about setting GroupSizes.
https://msdn.microsoft.com/DA-DK/library/windows/apps/xaml/system.globalization.numberformatinfo.numbergroupsizes

Please let us know if you have any queries.

Thanks,
Sivakumar

[Amit Saraf]

Hi Amit,

You can achieve your requirement by setting GridNumericColumn.NumberGroupSizes  and GridCurrencyColum.CurrencyGroupSizes properties. Find the code snippet below,

<Syncfusion:GridNumericColumn NumberGroupSeparator="," MappingName="EmployeeSalary">

    <Syncfusion:GridNumericColumn.NumberGroupSizes>

        <Int32Collection>3,2,2,0</Int32Collection>

    </Syncfusion:GridNumericColumn.NumberGroupSizes>
</Syncfusion:GridNumericColumn>

Documentation:
http://help.syncfusion.com/wpf/sfdatagrid/column-types#gridcurrencycolumn
http://help.syncfusion.com/wpf/sfdatagrid/column-types#gridnumericcolumn

Refer below msdn link to understand about setting GroupSizes.
https://msdn.microsoft.com/DA-DK/library/windows/apps/xaml/system.globalization.numberformatinfo.numbergroupsizes

Please let us know if you have any queries.

Thanks,
Sivakumar

Thanks for your help

It worked and I got result as wanted.

Amit Saraf

[Ashwini Paranthaman]

Hi Amit,
Thank you for the update.
Please let us know if you need any other assistance.
Regards,
Ashwini P.