Footer Getting Sort

Posted by: taufikpatel717 on 2 April 2023, 5:56 pm EST

    • Post Options:
    • Link

    Posted 2 April 2023, 5:56 pm 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.

  • Posted 2 April 2023, 8:38 pm EST

    Can Anyone Solve This

  • Posted 3 April 2023, 4:18 pm 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

  • Posted 3 April 2023, 4:40 pm 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.

  • Posted 5 April 2023, 6:24 am 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

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels