Passing Parameters to a Report in Dynamics AX

Creating reports in AX is generally ‘a walk in the park’ even for the new developers not fully acquaint with the syntax of X++. However, it sometimes becomes challenging to understand how the parameters could be passed to a report when you want to initiate that report from a form.

Let’s look at an example where you may want to create a ‘Purchase Requisition Report’ that the users could generate to see the status of each purchase requisition and the associated workflow entries for that Purchase Requisition.

I will not go into the details of how to develop this report, but you should know that such a report do not exist in the out-of-the-box functionality within AX 2009.

So let’s say that you have developed this report and now when you generate this report you can pass on the required ‘Purchase Requisition ID’ in the ‘Parameter Prompt’ of the report to view the particular PR details accordingly.

However, now in the next step you want to call this report from the ‘Purchase Requisition Form’ (i.e PurchReqTable). To do this, you should first create a ‘Button’ within the ButtonGroup on the form.

Now right-click on the ‘Methods’ node within the newly created button and choose ‘Override Method –> clicked’

Within the clicked function, you should write the following code;

void clicked()
{

    Args args = new args();
    ReportRun       reportRun;
;

    args.parm(PurchReqTable.PurchReqId);

    args.name(reportstr(PurchRequisitionDetails));
    reportRun = classFactory.reportRunClass(args);
    reportRun.init();
    reportrun.run();
    //hello

    super();
}

The above code calls the args() system class. This class is used to pass arguments to a class-constructor. You can pass information such as name, caller, and parameters to a new class. This code passes the relevant Purchase Requisition ID (which is currently selected by the user on the form) to the report ‘PurchRequisitionDetails’ in the above code.

Now, you need to go to the report (which in this case is PurchRequisitionDetails). Right-Click on the methods node of the Report and click on ‘Override Method –> init’

In this init method, you need to enter the following code to allow the report to read the parameters from the form.

public void init()
{
;
    try
    {
          if(element.args().parm())
          {
                this.query().dataSourceTable(tablenum(PurchReqTable))
               .addRange(fieldnum(PurchReqTable,    PurchReqId)).value(element.args().parm());

               this.query().userUpdate(false);
               this.query().interactive(false);
               super();
         }
     }

     catch(exception::Error)
     {
           info(“Error in init method”);
     }

}

 Once you have got the above code correctly entered, you should now be able to generate your report directly from the form.

All the best.

Advertisements

About rehanaqeel

Rehan is currently working as the Senior Project Manager for the implementation of ERP (Dynamics AX), Fleet Management System, Intranet, and View all posts by rehanaqeel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: