Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

how i will get sales tracker in report dialog?

(0) ShareShare
ReportReport
Posted on by

hi all,

i am working on a report. that need sales tracker as report parameter means in report dialog,'

sales-tracker.jpg

1. how i will get sales tracker in report dialog?

2. how the sales tracker is related with sales id? i need relation between table.

i have searched, but not get proper answer...

please give me more shed on this.

thanks!

  • @rp@n Profile Picture
    @rp@n on at
    RE: how i will get sales tracker in report dialog?

    sure martin,

  • Martin Dráb Profile Picture
    Martin Dráb 230,848 Most Valuable Professional on at
    RE: how i will get sales tracker in report dialog?

    Good, it seems your question is now answered.

    Regarding your new question, please create a new thread and explain your problem in detail there.

  • @rp@n Profile Picture
    @rp@n on at
    RE: how i will get sales tracker in report dialog?

    thanks martin,

    now i am getting name and is in sales taker drop down. how i will get which sales order is tagged with the particular sales taker. based on the sales taker selection , i need to display the lines.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,848 Most Valuable Professional on at
    RE: how i will get sales tracker in report dialog?

    No, that's not what Sergei said. "You can use any EDT with relation to HcmWorker table, like HcmWorkerRecId" does not mean that you must create a new EDT. Use HcmWorkerRecId and you'll see that it indeed works.

    By the way, it's sales taker, not sales tracker.

  • @rp@n Profile Picture
    @rp@n on at
    RE: how i will get sales tracker in report dialog?

    Sergei,

    You told me to create a new EDT with relation HcmWorker. so, that i can get the drop down rite?

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: how i will get sales tracker in report dialog?

    hi @rp@n,

    If you can, change the type of the parameters in the DP class and contract class, and change the field EDT in your data set, just like when you add a parameter when creating a new report, just change it to other parameter.

  • @rp@n Profile Picture
    @rp@n on at
    RE: how i will get sales tracker in report dialog?

    This is new report. Just tell me how I will get drop down in sales tracker in dialog.

    This is my question

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: how i will get sales tracker in report dialog?

    Hi @rp@n,

    which report do you used?

    Can change dataset table field EDT type?

  • @rp@n Profile Picture
    @rp@n on at
    RE: how i will get sales tracker in report dialog?

    Hi blue

    This is excel export report. Not having do or controller class.

    I have already checked it's coming from dirpartytable.nane field.( sales tracker )

    So, I am asking how will get I'd a d name field as a drop down in sales tracker?

    Please give me more shed on this

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: how i will get sales tracker in report dialog?

    HI @rp@n,

    You can check your contract class and DP class, and your dataset field, which  EDT is used.

    Then in EDT, expand Table relations, there will be a field of data source, the value you select in the drop-down box comes from there.

    0005.PNG97.PNG

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans