Passing Current record's value in Parameter dialog box of SSRS report

(0) Share

Report

Posted on by Ayush Thapliyal

Hi everyone,

I need to create a custom report so that when I select a record and click on the menu item button that runs the report. firstly a parameter dialog box should open up with pre selected quantity field from the record. And then the report should run when I hit OK.
I have created a UI Builder class to build the dialog box but I don't know how I can automatically fill the quantity dialog field in that.
Rest everything I have successfully completed.

Please help, Its urgent.

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

BrandonSA 1,669 on at

Like (0)

Report

RE: Passing Current record's value in Parameter dialog box of SSRS report

Hi Ayush

You will also need to update your controller and contract class.

Here are some examples:

rajendraax.wordpress.com/.../ssrs-report-by-using-controller-class-sample-code

This one might be really useful, except this one tries to bypass the dialog altogether. You could modify this code so that the dialog shows - just populated with your values: (this is where ievgen's response comes into play)

www.bhsolutions.com/.../how-to-launch-an-ssrs-report-from-ax-with-pre-loaded-parameters

Hope this helps
Suggested answer

Mea_ 60,278 on at

Like (0)

Report

RE: Passing Current record's value in Parameter dialog box of SSRS report

You can override preRunModifyContract method of the controller as shown in this blog 360dynamics.blogspot.com/.../ax-2012-prerunmodifycontract-method-in.html