DrillThroughProvider in SSRS Reports

(0) Share

Report

Posted on by Martin Gelev

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?

Categories:

Reporting and BI

Development / Customization / SDK

All responses (4)

Answers (1)

Suggested answer

Community Member on at

Like (1)

Report

RE: DrillThroughProvider in SSRS Reports for AX 7

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)
Community Member on at

Like (0)

Report

RE: DrillThroughProvider in SSRS Reports for AX 7

Thanks Martin, I resolved the issue.
Verified answer

Martin Dráb 232,996 Most Valuable Professional on at

Like (0)

Report

RE: DrillThroughProvider in SSRS Reports for AX 7

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

Like (0)

Report

RE: DrillThroughProvider in SSRS Reports for AX 7

HI Martin,

Did you resolved the above issue?