Microsoft Dynamics CRM (Archived)

Sum for subgrid and show in main form

(0) Share

Report

Posted on by Community Member

Hello friends,

how to sum the values in subgrid and show in main form

for example :

main form name = ABC

sub grid name = 123

this is subgrid

5277.Capture.JPG

Total Amount value should show in main form and one field

please send me the java script or plugin code.

thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (21)

Answers (1)

Suggested answer

Pitipe 686 on at

Like (1)

Report

Do you specifically want code?

This is easily done via a rollup field in the main entity, when you configure the Rollup Field, the related entity will be that of the sub grid and the aggregation will be the Sum of ( I am assuming based on screen shot) the Total Amount field.

Was this reply helpful? Yes No
Suggested answer

Sateesh123 132 on at

Like (1)

Report

Hi Arunkumar,

You can go for Rollup field instead of coding.

this is for your reference : technet.microsoft.com/.../dn832162.aspx

Was this reply helpful? Yes No
Suggested answer

MNarmeen 1,848 on at

Like (3)

Report

Make a field in main form with the name lets say "OverallAmount"

and then add the following javascript code.

function GetGridValues()

{

var rowData;

var entity;

var attribute;

var i=0;

var qty=0;

var count=0;

var filteredRecordCount = Xrm.Page.getControl("123").getGrid().getTotalRecordCount();

rowData = Xrm.Page.getControl("123").getGrid().getRows().get(0).getData();

entity = rowData.getEntity();

attribute = entity.getAttributes();

qty= attribute.get(“new_amount”).getValue();

for( i=1; i<filteredRecordCount ; i++)

{

rowData = Xrm.Page.getControl("123").getGrid().getRows().get(i).getData();

entity = rowData.getEntity();

attribute = entity.getAttributes();

qty= attribute.get(“new_amount”).getValue();

count=count+qty;

}

Xrm.Page.getAttribute(“new_overallamount”).setValue(count);

}

If the above code doesnt work, use the following for currency fields

Xrm.Page.data.entity.attributes.get(“Currency field name”).getValue();

Xrm.Page.data.entity.attributes.get(“Currency field name”).setValue(Value);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i copy paste in notepad and saved .js format,

i uploaded in websources next what i need to do.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Use rollup field to do the same. Please go through my blog link regarding rollup fields. I explained same scenario there.

suyati.com/how-to-set-calculated-and-roll-up-fields-in-ms-dynamics-crm

Thanks...

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Please use the screenshot for your reference.

1) create a rollup field

2) in 'edit' option

Thanks..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i did that nly but not working

Was this reply helpful? Yes No
Pitipe 686 on at

Like (0)

Report

Hi Arankumar

It take a few hours for a Rollup to automatically populate. Click into the Parent record and you will be able to refresh the field to populate the value. Is it still blank after doing that?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am getting this error... can you please help me

Was this reply helpful? Yes No
Pitipe 686 on at

Like (1)

Report

Just to confirm, the field you have created for the rollup is currency format and you have currency on the opportunity (and the field is populated)?

Was this reply helpful? Yes No