Calculate total programatically

Answers

• Options

  RockWithNAV Member Posts: 1,139

  2019-04-05

  And thats totally depends on the grouping of your Report like how you have maintained it.

  Thanks
  
  Blog - rockwithnav.wordpress.com/
  Twitter - https://twitter.com/RockwithNav
  Facebook - https://facebook.com/rockwithnav/

  0
• Options

  foxclub Member Posts: 16

  2019-04-08

  Hello,
  
  =sum(Fields!Qty_TransShptLine.Value)
  
  This is how i calculated the total quantity in "transfer shipment" report.
  Unfortunately sum obtained was wrong.

  0
• Options

  omyvadiya Member Posts: 124

  2019-04-08

  when you see the Report preview, go to About this report and export the data in excel and check where is the correct value is coming & use last instead of sum if correct value is in the last row or if the correct value is the first value then use the first instead sum.
  if the value is coming somewhere in between, then you have to write code on the onaftergetrecord of the record and have to use that variable's sum or last in the rdlc expression.

  0
• Options

  foxclub Member Posts: 16

  2019-04-09

  
  using last or first instead of sum did not work. Then how please could I use that by code.
  I tried in OnAfterGetRecord():
  totQty:="Transfer Shipment Line".Quantity;
  However no result.

  0
• Options

  wolfskin Member Posts: 84

  2019-04-09

  foxclub wrote: »

  using last or first instead of sum did not work. Then how please could I use that by code.
  I tried in OnAfterGetRecord():
  totQty:="Transfer Shipment Line".Quantity;
  However no result.

  
  In case of you want to use a variable to accumulate the values please try this code
  

  totQty += "Transfer Shipment Line".Quantity;
  

  
  Never forget to clear your variable every time the grouping key is changed.

  0