How to call query based ssrs report from form button click method in AX 2012?

(0) Share

Report

Posted on by Karthik Desappan

5,680

Hi Everyone,

I have created a new ssrs report for customer with transaction from AOT query. When normally generate report from menuitem it is easy but I want to call the report in customer form.i add one button in customer form design node and how pass the selected customer record to report to display a form currently selected data.

Thanks,

A.D.Karthik

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Just use a menu item button. Drag your menu item to a button group and a menu item button gets created automatically. Then set DataSource property to the data source that you want to use for filtering. That's all what you have to do in the form.

The report must be able to handle the record it receives from the form, of course, but that's another topic.

Was this reply helpful? Yes No
Karthik Desappan 5,680 on at

Like (0)

Report

Hi martin,

when use menuitem the record select in from to click report menuitem button in form showing param dialog and also not select the currrrent record value.

Was this reply helpful? Yes No
Karthik Desappan 5,680 on at

Like (0)

Report

when use menuitem the record select in form to click report menuitem button in form showing param dialog and also not select the currrrent record value.i need do not show parm dialog run report directly get args value from form selected value.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

You need not implement you requirement using Controller class

Please review following link

msdn.microsoft.com/.../srsreportruncontroller.aspx

please verify and let us know if you need more details, how to implement your requirement.

Was this reply helpful? Yes No
Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Karthik

If you want also suppress the Parm Dialog form, I suggest you to use the Report Data Provider class.

Take a look to technet.microsoft.com/.../ee909902.aspx

(Guidance for Choosing the Data Source Type [AX 2012])

stackoverflow.com/.../passing-parameters-from-form-to-aot-query-ax-2012

Was this reply helpful? Yes No
Karthik Desappan 5,680 on at

Like (0)

Report

hi denis/nithesh,

I created a report following link based:

www.abubakershekhani.com/.../create-ssrs-report-query-based-ms-dynamics-ax

the above link are showing create query based report and deploy into ax and create menuitem to run the report based on parameter.

if u take a above link as report for customer when use this report call from customer form button clicked method run the report only selected customer in the customer form.

plz see the above link and how to the call the report in customer form and display the report only selected customer....while calling parameter dialog not showing......

Thanks,

A.D.Karthik

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

Like (0)

Report

As Nitesh said, create a report controller class and implement what you need there. You can skip dialog by calling run() directly (instead of startOperation()) or by parmShowDialog(false).

Was this reply helpful? Yes No