Adding parameter to AX SSRS Report

Adding RDP parameter to report

Let us see how to add parameter to existing report. We will take up customer transaction report and add from date and to date as parameters.

Step 1: Create 2 parm methods in CustTransListContract

 For FromDate and ToDate

/// <summary>

/// Gets or sets the value of the datacontract parameter FromDate.

/// </summary>

/// <param name="_fromDate">

/// The new value of the datacontract parameter FromDate; optional.

/// </param>

/// <returns>

/// The current value of datacontract parameter FromDate.

/// </returns>

[

    DataMemberAttribute('FromDate'),

    SysOperationHelpTextAttribute(literalStr("@SYS26930"))

]

public FromDate parmFromDate(FromDate _fromDate = fromDate)

{

    fromDate = _fromDate;

    return fromDate;

}

/// <summary>

/// Gets or sets the value of the datacontract parameter ToDate.

/// </summary>

/// <param name="_toDate">

/// The new value of the datacontract parameter ToDate; optional.

/// </param>

/// <returns>

/// The current value of datacontract parameter ToDate.

/// </returns>

[

    DataMemberAttribute('ToDate'),

    SysOperationHelpTextAttribute(literalStr("@SYS26929"))

]

public ToDate parmToDate(ToDate _toDate = toDate)

{

    toDate = _toDate;

    return toDate;

}

Step 2: Check for initialisation code in processReport method of CustTransListDP class

  contract = this.parmDataContract() as CustTransListContract;

Step 3: Assign the parameter value to local variable and use it for filtering in process report.

FromDate FromDate;

ToDate  ToDate;

fromDate = contract.parmDate();

toDate   = contract.ToDate();

if ((cursor.TableId == custTable.TableId ||

                    !(remainAmount &&

                (custTrans.CurrencyCode ? custTrans.AmountCur == custTrans.SettleAmountCur : custTrans.AmountMST == custTrans.SettleAmountMST))) &&

                (custTrans.TransType != LedgerTransType::ExchAdjustment ||

                (custTrans.TransType == LedgerTransType::ExchAdjustment && this.balanceMST(exchangeAdjustmentType) != 0)) && (custInvoiceJour.InvoiceDate >= fromdate && custInvoiceJour.InvoiceDate <= toDate) )

{

// insertion code as is

}

Step 4: Add fromDate and ToDate form control(dialog control) in form(dialog) for end user input in CustTransListUIBuilder-> build method.

    FromDateField          = this.bindInfo().getDialogField(custTransListContract, methodStr(CustTransListContract, parmfromDate));

ToDateField          = this.bindInfo().getDialogField(custTransListContract, methodStr(CustTransListContract, parmToDate));

               

Step 5:Compile forward the contract class,UI builder and DP classes which were updated before.

Step 6: Open the report design in visual studio and check the parameters node available for fromDate and toDate

If Available,

Build and Deploy the report.

If parameter is unavailable then

                Delete CustTransListDS datasource in report

               

Right click datasets and add new dataset . Update the properties as below.

Click the continue button in property section in Query control. DP selection window will open.

Select CustTransListDP and all fields . Click next  and finish the wizard.

Redeploy the report.

Step 6: Delete report from report manager site.

Report manager url is available at following location.

System Administration -> Setup-> Business Intelligence -> Reporting Services-> Report servers

Redeploy the report.

Restart AOS.

Restart SSRS service.