Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Field In table extensi...
Finance forum

Field In table extension in not coming in Report

Posted on by 44
I have DP for my report and in that Data Provider I have few tables includingTrvExpTrans . I had extension of  TrvExpTrans( which I have created for another project), In that extension I have added field called ExpenseDate. Now when I am adding that table to DP class while creating Report. It is showing ExpenseDate like TrvExpTrans.ExpenseDate but when I am inserting the Value in tmp table it is blank in tmptable. And when I debug the code it seems that ExpenseDate value was not there infact ExpenseDate was not there for TrvExpTrans table. So, ExpenseDate was blank in my report. 

I need help in how Can I get ExpenseDate in my Report which is a field in Extension of TrvExpTrans. Let me know, if anyone need more explanation or Screen Shots
  • amandeepsin Profile Picture
    amandeepsin 44 on at
    Field In table extension in not coming in Report
    Hi All, Sorry I was away for a while. Just to be sure, I can see the field ( IntelliSense ) but I can't see the data in the field ( in diagnostic mode ). Therefore, in report field is empty
  • Raj Borad Profile Picture
    Raj Borad 315 on at
    Field In table extension in not coming in Report
    As mentioned by everyone, build model, syn database and other,
    If still issue is not resolved.
     
     
    My suggestion is to add that table extension (As you said that table extension (where field is added) is in another project), in your project and try to clean > then > build > synchronize the project > deploy reports.
     
    Thank you,
    Raj D Borad
     
  • Waed Ayyad Profile Picture
    Waed Ayyad 5,060 Super User 2024 Season 2 on at
    Field In table extension in not coming in Report
    Hi,

    Is your issue resolved?  If yes, mark the answers that helped you as verified.

    Thanks
    Waed Ayyad
  • Komi Siabi Profile Picture
    Komi Siabi 12,427 Super User 2024 Season 2 on at
    Field In table extension in not coming in Report
    Bonjour Aman, 
     
    You did mention that all other column are populating data except ExpenseDate. This would have if you did not build and Sync the project in which you created the table extension. So build and Sync as others have suggested.
     
    You could have this problem also if you had already created the Report before creating the table extension. To resolve the flow of data into the new field,
     
    • Restart the SSRS services under
    • Redeploy the SSRS report(using Visual studio 2019 preferably).
  • Layan Jwei Profile Picture
    Layan Jwei 6,868 Super User 2024 Season 2 on at
    Field In table extension in not coming in Report
    Hi,
     
    Just to understand, if you add ExpenseTrans.ExpenseDate to the watch, what does it return? And does ExpenseTrans buffer has a value in the first place?
     
    If ExpenseTrans RecId is 0, then it means there is an issue with your joins maybe. if ExpenseTrans has a a RecId and expenseDate has a value but ur TmpTable is not showing it then please build your model with sync, then deploy the report. After that clear usage data then give it another try
     
    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
  • Waed Ayyad Profile Picture
    Waed Ayyad 5,060 Super User 2024 Season 2 on at
    Field In table extension in not coming in Report
    Hi,
     
    Try to sync the Database.
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
  • amandeepsin Profile Picture
    amandeepsin 44 on at
    Field In table extension in not coming in Report
    Hi, 
     
    I am using DP class to get data from table. Here is my code
     
        TrvExpTrans ExpenseTrans;
        HcmWorker Workers;
        DirPersonName WorkerName;
        HcmPositionWorkerAssignment WorkerAssignment;
        HcmPositionDetail PositionDetail;
        DirPartyTable DepartmentTable;
        EmployeeOOPExpenseTmp EmployeeExpenseTmpDB;
        
     
       public void processReport()
        {
            super();
            
            while select ExpenseTrans
                join Workers
                where ExpenseTrans.CreatingWorker == Workers.RecId
                join WorkerName
                where Workers.Person == WorkerName.Person
                join WorkerAssignment
                where Workers.RecId == WorkerAssignment.Worker
                && ExpenseTrans.ExpenseDate >= DateTimeUtil::date(WorkerAssignment.ValidFrom) && ExpenseTrans.ExpenseDate <= DateTimeUtil::date(WorkerAssignment.ValidTo)
                join PositionDetail
                where WorkerAssignment.Position == PositionDetail.Position
                && ExpenseTrans.ExpenseDate >= DateTimeUtil::date(PositionDetail.ValidFrom) && ExpenseTrans.ExpenseDate <= DateTimeUtil::date(PositionDetail.ValidTo)
                join DepartmentTable
                where PositionDetail.Department == DepartmentTable.RecId
            {
                EmployeeExpenseTmpDB.FirstName = WorkerName.FirstName;
                EmployeeExpenseTmpDB.LastName = WorkerName.LastName;
                EmployeeExpenseTmpDB.AmountCurr = ExpenseTrans.AmountCurr;
                EmployeeExpenseTmpDB.AmountMST = ExpenseTrans.AmountMST;
                EmployeeExpenseTmpDB.CostType = ExpenseTrans.CostType;
                EmployeeExpenseTmpDB.ExpenseDate = ExpenseTrans.ExpenseDate;
                EmployeeExpenseTmpDB.DepartmentName = DepartmentTable.Name;
                EmployeeExpenseTmpDB.insert();
            }
            
        }


    I am getting data in all other fields except ExpenseDate in report. I have reset the dataset. Moreover, data is there in Database and yes, ExpenseDate was not there  while debugging I can't see other ExpenseDate Column in the buffer but can see other columns. 
  • Waed Ayyad Profile Picture
    Waed Ayyad 5,060 Super User 2024 Season 2 on at
    Field In table extension in not coming in Report
    Hi,
     
    Can you share your code? Also did you try to refresh dataset on the report? Try to reset usage data and Sync the Database.
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,115 Super User 2024 Season 2 on at
    Field In table extension in not coming in Report
    Hi Amandeepsin,

    You mentioned that the ExpenseData value was empty in the TrvExpTrans table buffer? Does the field have a value in the database? Can you share the coding how you retrieve the records from the TrbExpTrans table? If you are using an existing Query or View, the field might not be part of the selected fieds.

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,115 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,971 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans