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 :
Dynamics 365 Community / Forums / Finance forum / DrillThroughProvider i...
Finance forum

DrillThroughProvider in SSRS Reports

(0) ShareShare
ReportReport
Posted on by

Hi 

I create SSRS Report in AX 7 where I need to create link from InvoiceId field in the report to the form VendInvoiceJour. I try to use DrillThroughProvider.DrillInvoiceId but this Data Method is used for the form CustInvoiceJour, I am not sure is it possible and if it's possible how to create Data Method like in old AX 2012 or how to find already existing Data methods in DrillThroughProvider, can you help me with some suggestions?

I have the same question (0)
  • Community Member Profile Picture
    on at

    HI Martin,

    Did you resolved the above issue?

  • Verified answer
    Martin Dráb Profile Picture
    237,976 Most Valuable Professional on at

    Are you aware of GenerateDrillThroughLink()? You'll find details in How To: Add deep links to reports (SSRS).

  • Community Member Profile Picture
    on at

    Thanks Martin, I resolved the issue.

  • Suggested answer
    Community Member Profile Picture
    on at

    I think the best approach should be for Drill-Down report is one liner expression as shown below.

    =DrillThroughProvider.DrillInvoice(Parameters!AX_ReportContext.Value, First(Fields!InvoiceId.Value, "SalesInvoiceDS"))

    Where in "DrillInvoice", "Invoice" is created "FieldGroup" in respected table "CustInvoiceJour" which contains "InvoiceId" along with other fields. Other fields doesn't matter, only "InvoiceId" should be there.

    What you need to, do everything as it is to fetch information related to particular field. In properties "Action" tab write the above expression according to your field. This is nothing but expression to fetch the information from DS.

    First(Fields!InvoiceId.Value, "SalesInvoiceDS" (Header)

    or

    Fields!Name.Value (Line or table)

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans