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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Drill Down Report

(0) ShareShare
ReportReport
Posted on by 5

New in D365FO. Please help. I have tried a lot but not able to do this. Want a simple Drill Down ( Not Drill through )

Custgroup  will be appeared in screen. Then clicking on Cust Group Customer account code and name will appear as a drill down.

Hope somebody will be able to help me.

I have the same question (0)
  • Suggested answer
    huijij Profile Picture
    19,811 on at
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    You can setup financial reports with the customer and other financial information to achieve this.

    Have you tried that financial report design already?

    Best regards,

    Ludwig

  • D365FO Drill Down Report Profile Picture
    5 on at

    Hi

    Thanks for your early reply

    What I have tried mentioned below

    1. One query has been created for CustGroup with CustTable

    2. In the report I have used this query

    3. My objective is to get a simple output

    Customer Group 10

    Customer Group 20

    Now if I click on Group 10

    Group 10  C/000001 Harris

    Group 10  C/000002 Edwards

    Like this. I have searched all the links shared here but did not find out any actual example or guide. On Microsoft docs it's only referring Applicable to 2012 R2

    Not in D365FO 

  • D365FO Drill Down Report Profile Picture
    5 on at

    Hi Judi

    Thanks. Searched all the links already including your 2nd link. That is specific to 2012 and many of the features not available in D365FO. Please see my post if you can further help. I want to use a query including custgroup & custtable to get the group wise customer on clicking on group

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    Can you specify what kind of report you want to create?

    A BI report in PowerBI, a financial report in the financial reporter, a SSRS report in D365FO or another kind of report?

    Many thanks,

    Ludwig

  • D365FO Drill Down Report Profile Picture
    5 on at

    Hi Guys

    Resolved the Issue. I was trying Auto design instead of precision design.

    It's worked 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans