News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Active Record pass as ...

Microsoft Dynamics AX (Archived)

Active Record pass as a parameter to the query base report

(0) Share

Report

Report

Posted on by veeru ogu

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

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 8,705 on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans