Dynamics Community Forum Thread Details

My Custom SSRS Report Does not read a new Field in Table Extension

I want to create a custom BankAccountStatement SSRS report in Dynamics 365 Finance & Operations.

I have created:

A new Report Design
A new Output Item
An extension of BankAccountStatementDP
An extension of BankAccountStatementTmp

I added a custom field called Description, and its Extended Data Type is TransactionTextLarge in BankAccountStatementTmp.

The Description field should contain the data from the Txt field in the BankAccountTrans table.

In my Data Provider extension, I have the following code X++:

[ExtensionOf(classStr(BankAccountStatementDP))] 

final class BankAccountStatementDP_AlAfdal_Extension 

{ 

    public void processReport() 

    { 

        BankAccountStatementTmp tmp; 

        BankAccountStatementTmp tmpNew; 

        BankAccountTrans        bankAccountTrans; 

  

        next processReport(); 

  

        while select tmp 

        { 

            tmpNew.data(tmp);  

  

            select firstOnly Txt, AmountCur 

                from bankAccountTrans 

                where bankAccountTrans.AccountId == tmp.AccountID 

                   && bankAccountTrans.Voucher   == tmp.Voucher; 

  

            if (bankAccountTrans) 

            { 

                tmpNew.Description = bankAccountTrans.Txt; 

  

                if (bankAccountTrans.AmountCur > 0) 

                { 

                    tmpNew.AmountDebit  = bankAccountTrans.AmountCur; 

                    tmpNew.AmountCredit = 0; 

                } 

                else 

                { 

                    tmpNew.AmountCredit = abs(bankAccountTrans.AmountCur); 

                    tmpNew.AmountDebit  = 0; 

                } 

            } 

  

            tmpNew.insert(); 

            tmp.delete();     

        } 

    } 

}

When I run the report, it runs successfully, but the Description column is empty and does not display any data.

the result I expcted