web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / how i will get sales t...
Finance | Project Operations, Human Resources, ...
Answered

how i will get sales tracker in report dialog?

(0) ShareShare
ReportReport
Posted on by @rp@n 56

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!

I have the same question (0)
  • Verified answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,097 on at

    Hi @rp@n,

    1. The sales taker is just a worker. So you can use any EDT with relation to HcmWorker table, like HcmWorkerRecId.

    2. Sales taker is selected on sales order on the header level. I guess your requirement is to filter out orders for a report by sales taker and in this case you just need add filter by related field in SalesTable with the value from the dialog.

  • Suggested answer
    Vishal Dhavgaye Profile Picture
    Vishal Dhavgaye 405 on at

    What report you trying to modify? Is it standard report or custom report.

    Please check the following link for similar requirement to modify report dialog,

    community.dynamics.com/.../ssrs-rdp-report-new-parameter

  • @rp@n Profile Picture
    @rp@n 56 on at

    Yes Sergei,

    In my report dialog I have

    From date , to date, customer group, sales tracker.

    Kindly let me know how I will get name and I'd in sales tracker drop down?

    Please send me the code

  • Blue Wang Profile Picture
    Blue Wang Microsoft Employee on at

    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

  • @rp@n Profile Picture
    @rp@n 56 on at

    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 Microsoft Employee on at

    Hi @rp@n,

    which report do you used?

    Can change dataset table field EDT type?

  • @rp@n Profile Picture
    @rp@n 56 on at

    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 Microsoft Employee on at

    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 56 on at

    Sergei,

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

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 239,684 Most Valuable Professional on at

    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.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 668 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 630 Super User 2026 Season 1

#3
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 581

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans