Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

How to add additional comments on runtime of a report

Posted on by 110

Hi there,

I have created a report and it was executing as expected, but I was stuck with 3 things in the report.

  • We want to add the comments or notes on the report before execting it.I'm not sure how to acheive this scenario, but I was told that we can write in the RDP class. this is the first time i faced like this scenario. 

My scenario is explained below.

pastedimage1641879819964v1.png

pastedimage1641880510448v2.png

         2. we want a show the sales responsible name of the sales order in the report. 

           we gave a condition like this in RDP  productDispatchTmp.WorkerSalesReponsible        = HcmWorker::find(locSalesTable.WorkerSalesResponsible).Person;

          we are getting the Number instead of Name.  

         3. how to get the contact information of a customer into a report.

            let say in the SalesOrder, if we tap on the Header of the SO, we have a customer account number. if we click on the Cust Account, it will the Cust Account details, we want get the details of the Contact information of the customer on the report.

Any leads, please help me to acheive this scenario.

Thank you,

Kind regards

Seshu Nara

  • Verified answer
    AT982020 Profile Picture
    AT982020 509 on at
    RE: How to add additional comments on runtime of a report

    1. Create a data contract class, and then inside the data provider class, call the contract class to access the parameters

    2. Try this: HcmWorker::find(locSalesTable.WorkerSalesResponsible).name()

    3. That depends on your approach. If your report is query based, you could edit the query to get the relevant info, or you could fetch the customer info inside the data provider using a SQL statement

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans