How to get selected record id in query in print layout report in SSRS

(0) Share

Report

Posted on by CU21091228-0

230

Hi Team,

I am developing new print layout SSRS report.

Here if i select Particular record and click on report menu item, same selected record id should we set in dialog box.

Please let me know how to achieve this.

I have the same question (0)

All responses (4)

Answers (0)

Martin Dráb 236,962 Most Valuable Professional on at

Like (0)

Report

How to get selected record id in query in print layout report in SSRS in D365FO

Is it a query-based report or a reporting using an RDP class?

Was this reply helpful? Yes No
CU21091228-0 230 on at

Like (0)

Report

How to get selected record id in query in print layout report in SSRS in D365FO

Using RDP class.

Was this reply helpful? Yes No
Martin Dráb 236,962 Most Valuable Professional on at

Like (0)

Report
How to get selected record id in query in print layout report in SSRS in D365FO

It's not clear which part you're struggling with, so here is a brief overview.

Use a menu item button to call your report controller.

In controller's main(), you should see the active record in _args.caller(). But don't do anything with it there, simply pass it to the controller through parmArgs().

In prePromptModifyContract(), modify the query. The safest way is removing all existing filters for the given field and then adding one for the value from args.record().

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report

How to get selected record id in query in print layout report in SSRS

Hi,
Related articles and discussions are mentioned in the link below, you can check it for reference.
Running an SSRS report from the selected record | NevoiTech Blog
Filter SSRS report by selected record - Dynamics 365 for Finance and Operations/AX / Developer Forum - Dynamics User Group
Best Regards,
Hana

Was this reply helpful? Yes No