Dynamics Community Forum Thread Details

What is the best way to include the total of any column in a Word Layout Report Extension?

Hi Everyone,

This is a Word layout Report Extension, and I am trying to sum of Sales Amount column that I have added to a report where I want to sum the sales amount. Please let me know what I need to do. I have searched a lot but did not find documentation about Word layouts related to totaling.

reportextension 51011 DetailSalesPersonReportExt extends 7141758
{
    dataset
    {
        add(DetailedCommissEntry)
        {
            column(Payment_Date; Format(paymentDate)) { }
            column(Sales_Amount; "Sales Amount")
            {
            }
        }
        add(Totals)
        {
            column(TotalSalesAmt; TotalSalesAmt)
            {
            }
        }
        modify(Totals)
        {
            trigger OnAfterAfterGetRecord()
            var
            // DetailCommissionEntry: Record "IDPCOS Detailed Commiss. Entry";
            begin
                TotalSalesAmt += DetailedCommissEntry."Sales Amount";
            end;
        }
    }
    requestpage
    {
    }



    rendering
    {
        layout(NewLayout)
        {
            Type = Word;
            LayoutFile = 'Layouts/Detail SalesPerson Default - Letter.docx';
            Caption = 'Custom layout By UC (Letter Formart)';
            Summary = 'Includes the information most commonly requested by users.';
        }
    }
    labels
    {
        PaymentDateLbl = 'Payment Date';
        ProfitLbl = 'Profit Amount';
        SalesAmountLbl = 'Sales Amount';
    }
    trigger OnPreReport()
    var
        LastDocumentNo: Code[20];
        RecRef: RecordRef;
        DetailCommissionEntry: Record "IDPCOS Detailed Commiss. Entry";
    begin
        /*  Clear(TotalSalesAmt);
         TotalSalesAmt := 0; */
        /* 
            DetailCommissionEntry.Reset();
           // DetailCommissionEntry.CopyFilters(Salesperson);
            if DetailCommissionEntry.FindSet() then
                repeat
                    TotalSalesAmt += DetailCommissionEntry."Sales Amount";
                until DetailCommissionEntry.Next() = 0; */
    end;
    trigger OnPostReport()
    var
        myInt: Integer;
        LastDocumentNo: Code[20];
    begin


    end;
    var
        PaymentDateLbl: Label 'PaymentDate';
        ProfitLbl: Label 'ProfitAmt';
        SalesAmountLbl: Label 'SalesAmt';
        TotalSalesAmt: Decimal;
}