Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How to add additional comments on runtime of a report

(0) ShareShare
ReportReport
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
    atajjo Profile Picture
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,925 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans