Footer Getting Sort

Footer Getting Sort

Posted by: taufikpatel717 on 3 April 2023, 2:56 am EST

• 

  taufikpatel717

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 April 2023, 2:56 am EST

  Hello Team ,

  I am Working on the flexGrid Footer. I am getting issue in the footer that it also gets sorting when i clicking the column . i attached ppt also . so I sended that row from the collectionview that also i attached in ppt can you please help me to solve this with sort issue.

• 

  taufikpatel717

  • Post Options:
  • Link
    Copy

  Posted 3 April 2023, 5:38 am EST

  Can Anyone Solve This

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 4 April 2023, 1:18 am EST

  Hi,
  
  The PPT, you shared is not attached in the case. Could you please recheck? Also, we tested it with the online demo sample:
  
  https://www.grapecity.com/componentone/demos/ASPNET/MVCExplorer/FlexGrid/CustomFooters
  
  But we are unable to replicate the issue at our end.

  Regards,
  
  Manish Gupta

• 

  taufikpatel717

  • Post Options:
  • Link
    Copy

  Posted 4 April 2023, 1:40 am EST

  if (allocCollection._src.length > 0) {
  
  let TotalSettlAmount = 0;
  
  let TotalClientNet = 0;
  
  let TotalRefereeFee = 0;
  
  let TotalExpenses = 0;
  
  let TotalWLFeePaid = 0;
  
  let TotalWLExpPaid = 0;

              for (var i = 0; i < allocCollection._src.length; i++) {
                  if (allocCollection._src[i].Voided != true) {
                      TotalSettlAmount += allocCollection._src[i].SettlementAmount;
                      TotalClientNet += allocCollection._src[i].ClientNetROPayment;
                      TotalRefereeFee += allocCollection._src[i].RefereeFee;
                      TotalExpenses += allocCollection._src[i].RefereeExpense;
                      TotalWLFeePaid += allocCollection._src[i].PaymentAmount;
                      TotalWLExpPaid += allocCollection._src[i].WLExpensePaid;
                  }
              }
              allocCollection._src.push({
                  ClientName: "Total",
                  SettlementAmount: TotalSettlAmount,
                  ClientNetROPayment: TotalClientNet,
                  RefereeFee: TotalRefereeFee,
                  RefereeExpense: TotalExpenses,
                  PaymentAmount: TotalWLFeePaid,
                  WLExpensePaid: TotalWLExpPaid
              });
          }
          ROSearchAllocations.Grid.settings({ collection: allocCollection });
  

  I Written the above code to do the footer. I calculated all sum and passed to the itemsource of the grid so now it is also getting sort with the data. so i want to stop the total to sort.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 5 April 2023, 3:24 pm EST

  Hi Taufik,
  
  Please refer to the demo sample for reference. https://www.grapecity.com/componentone/demos/ASPNET/MVCExplorer/FlexGrid/CustomFooters

  The FlexGrid provides the columnFooters which would add at the bottom position and would stick at the bottom. This would show Sum or Specified Value according to the Specified Aggregate.
  
  Instead of adding a manual row, please use the columnFooters. You may also set the value for the footers cell using

  grid.columnFooters.setCellData()

  Hope it helps!

  Regards,
  
  Manish Gupta