1. Home
  2. Forum
  3. ASP.NET Core - EJ 2
  4. Data Grid Value's Doesn't showing in Rupees

Data Grid Value's Doesn't showing in Rupees

Hi Team,

In Data grid I have used aggregate function for some columns and it result showing as a dollar currency format. I need a value as Indian Rupees format.

Need to displaying the value as "Rupees" in

  1.  Textbox
  2.  Datagrid column value
  3. Aggregate function Result Value


 Kindly do the needful. Thanks in Advance.

Thanks,

Siranjeevi V


Attachment: Rupees_Issue_c5380ad2.zip

8 Replies
JC Joseph Christ Nithin Issack Syncfusion Team July 19, 2022 07:46 PM UTC

Hi Siranjeevi,


  Greetings from Syncfusion support.


  Currently we are validating your query, we will provide further details on or before 22nd July, 2022. We appreciate your patience until then.


Regards,

Joseph I.


JC Joseph Christ Nithin Issack Syncfusion Team July 22, 2022 10:47 AM UTC

Hi Siranjeevi,


  Thanks for your patience.


  Based on your requirement, you want to set currency values in Indian Rupees format. Your requirement, can be achieved by changing the currency culture to `INR`. We have already discussed about this in the following documentation.


Documentation: https://ej2.syncfusion.com/aspnetcore/documentation/common/internationalization#setting-currency-code


Please refer the below code example.


 

<script>

    ej.base.setCurrencyCode('INR');

</script>

 


Please get back to us for further details.


Regards,

Joseph I.




KA KALPATHARU August 8, 2022 11:20 AM UTC

Hi  Joseph,


I have tried code which is mentioned earlier reply. But it not worked.


FYI,

Syncfusion Version = 19.4.0.48

ASP.net Core Version = 5


Thanks,

Siranjeevi v


Attachment: Currency_6bc99d63.zip

JC Joseph Christ Nithin Issack Syncfusion Team August 19, 2022 12:26 AM UTC

Hi Kalpathru,


  Sorry for the late reply,


   Currently we are validating your query, we will provide further details on or before 23rd August 2022. We appreciate your patience until then.


Regards,

Joseph I.


NS Nithya Sivaprakasam Syncfusion Team August 29, 2022 06:08 PM UTC

Hi Kalpatharu,


Sorry for the inconvenience caused.


Query:” Data Grid Value's Doesn't showing in Rupees”


We are validating your query with the provided details and sample. We will update further details by tomorrow. Until then, we appreciate your patience.


Regards,

Nithya Sivaprakasam.


AR Anbumani Rajendracholan Syncfusion Team September 1, 2022 05:53 PM UTC

Hi Siranjeevi,


Sorry for the inconvenience caused.


Query:” Data Grid Value's Doesn't showing in Rupees”


We could reproduce the reported issue “Data Grid Value's Doesn't showing in Rupees” and we are validating this in our source currently. So, we will update the further details on Sep 5th, 2022. Until then we appreciate your patience.


Regards,

Anbumani Rajendracholan


KA KALPATHARU replied to Anbumani Rajendracholan September 22, 2022 04:49 AM UTC

Hi , team

We are still waiting for your response,
when can we expect answer from your side , its urgent.
kindly reply ASAP.

Thanks,
Kalpatharu.


JC Joseph Christ Nithin Issack Syncfusion Team September 22, 2022 04:06 PM UTC

Hi Kalpathru,


Sorry for the inconvenience caused.


Based on your requirement, you want to change the currency format from dollar to rupees. Your requirement can be achieved using the valueAccessor feature of the EJ2 Grid, using which you can customize the display text of the values in a particular column.


Please refer the below code example.


 

@{

    var valueAccessor = "valueAccessorFn";

} 

 

<ejs-grid id="Grid" dataSource="@ViewBag.dataSource">

    <e-grid-columns>

        <e-grid-column field="OrderID" headerText="Order ID" textAlign="Right" width="100"></e-grid-column>

        <e-grid-column field="CustomerID" headerText="Customer ID" type="string" width="120"></e-grid-column>

        <e-grid-column field="Freight" headerText="Freight" valueAccessor="valueAccessor" textAlign="Right" width="120"></e-grid-column>       

        <e-grid-column field="ShipCountry" headerText="Ship Country" width="150" ></e-grid-column>

        <e-grid-column field="Verified" headerText="Verified" width="150"></e-grid-column>

   </e-grid-columns>

</ejs-grid>

 

<script>

    function valueAccessorFn(field, data, column){

        var formattedValue = data.Freight.toLocaleString(

      'en-IN',

      {

        maximumFractionDigits: 2,

        style: 'currency',

        currency: 'INR',

      }

    );

    return formattedValue;

    }

</script>

 


Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/CoreSampleNet6634108236


Please get back to us for further details.


Regards,

Joseph I.


Loader.
Up arrow icon