Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Active Record pass as a parameter to the query base report

Posted on by 3,851
Hi All, I have created an Query based ssrs report , then I need to pass the active record on a form as a parameter to the report? ex: I have created sales transaction report using Query . This report attached on actionpan of a salesorder from . based on a form active record i want to shown the details of particular salesid in a report? Thanks veer

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Active Record pass as a parameter to the query base report

    As per my understanding, using Query based report you will not be able to implement this feature in your report

    You need to create a SSRS report usign RDP , Contract and controller class

    Please verify

  • Dick Wenning Profile Picture
    Dick Wenning 8,705 on at
    RE: Active Record pass as a parameter to the query base report

    look at forms where you can open old invoices of salesorders. copy that example.

    in general the dataprovider of the repost has an contract. just add the right values in the contract so the query behind this class will use the filter.

    ore look at

    msdax.wordpress.com/.../ssrs-report

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans