Field In table extension in not coming in Report

(0) Share

Report

Posted on by amandeepsin

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

Categories:

Development / Customization / SDK

All responses (1)

Answers (0)

André Arnaud de Cal... 287,773 Super User on at

Like (0)

Report

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.