Dynamics Community Forum Thread Details

Object reference not set to an instance of an object when restore a dataset in ssrs report

I have a SSRS report that i want to add a field (txt) in it, the field is in the main table (BankAccountStatement), and not in the tmp table, so i extended the tmp table and added a field of the same data type, then i created a class:

internal final class Ex_EventHandler
{
    [DataEventHandler(tableStr(BankAccountStatementTmp), DataEventType::Inserting)]
    public static void BankAccountStatementTmp_onInserting(Common sender, DataEventArgs e)
    {
        BankAccountStatementTmp BankAccountStatementTmp = sender as BankAccountStatementTmp;
        BankAccountTrans BankAccountTrans;
        while select Txt from BankAccountTrans where BankAccountTrans.AccountId == BankAccountStatementTmp.AccountID
        {
            BankAccountStatementTmp.Txt = BankAccountTrans.Txt;
        }
    }
}

When i want to restore the dataset in the report to let my new field (txt) to be available to add it to the design, it says to me that the "Object reference not set to an instance of an object" when restoring the dataset.

Adding that when I created a new dataset with the query, the field txt is showing, and I built my model with database synchronization.

My main and only goal is to add a new field to the design, that's it, why am I getting this error?

Categories:

Dynamics 365 Finance

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL