SSRS Report calling mechanism from form

I have made some of the reports and now I want to call this report one from the main navigation area of account receivable that i have done by using menu item .

Also I want to show the same report from the tab on the form for which I want to show the report for the same Invoice Account which I have selected by just clicking the mouse button on the same invoice Account.

I mean to say is the report should get open for the same Invoice account which I have selected at that time ...

Also I want to mention that I have use the rdp class as the data source in Ax 2012.

I hope I got it right... do you want to print the report for the selected (highlighted) record? Since you are using RDP classes, it is not a big issue, you just have to overwrite the prePromptModifyContract() method on the report controller class.

Here is an example of code for prePromptModifyContract() method which checks if there were any args passed through the menu item button (a datasource arg). And if there was a current buffer, then based on the record data the main query of the report will be modified - a new range for InvoiceAccount will be set up.

protected void prePromptModifyContract()
{
    Query                       myQuery;
    CustTable      custTableBuffer;
    ;

    if (this.parmArgs()             &&
        this.parmArgs().record()    &&
        this.parmArgs().dataset() == tableNum(CustTable))
    {
        custTableBuffer = this.parmArgs().record();

        myQuery = this.parmReportContract().parmQueryContracts().lookup(this.getFirstQueryContractKey());
        if (myQuery)
        {
            myQuery.dataSourceTable(tableNum(CustInvoiceJour)).clearRanges();
            myQuery.dataSourceTable(tableNum(CustInvoiceJour)).addRange(fieldNum(CustInvoiceJour, InvoiceAccount)).value(custTableBuffer.AccountNum);
        }
    }

    super();
}

Don't forget to choose the datasource to be passed on the menu item button.

Janis.

When wanting to clear dynalinks between two forms, you can clear the dynalinks on the DS on the second form. See example below.

Clear DynaLinks public void init() { ; super(); if (element.args() && element.args().caller() && (element.args().caller().name() == formStr (PurchTable))) { InventTable_ds.query().dataSourceTable(tableNum(InventTable)).clearDynalinks(); } }

Dynamics Axapta: Sales Orders & Business Connector

Well, again folllowing my same idea of writting close to nothing and pasting code, I'll paste in some code to create a sales order from some basic data and the invoice it. I'll try to explain more in the future. AxaptaObject axSalesTable = ax.CreateAxaptaObject("AxSalesTable"); AxaptaRecord rcInventDim = ax.CreateAxaptaRecord("InventDim"); AxaptaRecord rcCustTable = ax.CreateAxaptaRecord("CustTable"); rcCustTable.ExecuteStmt("select * from %1 where %1.AccountNum == '" + MySalesOrderObject.CustAccount + "'"); if (MySalesOrderObject.CurrencyCode.Trim().Length == 0) MySalesOrderObject.CurrencyCode = rcCustTable.get_Field("Currency").ToString().Trim(); string sTaxGroup = rcCustTable.get_Field("taxgroup").ToString().Trim(); //set header level fields axSalesTable.Call("parmSalesName", MySalesOrderObject.SalesName.Trim()); axSalesTable.Call("parmCustAccount", M

Passing values between form and class

Class name is EmplDuplication and Form is EmplTable . void clicked() { MenuFunction mf; args args = new Args(); ; args.record(EmplTable); mf = new menufunction(identifierstr(EmplDuplication), MenuItemType::Action); mf.run(args); } Meanwhile, in the main() method of the EmplDuplication class, we need to put this Axapta x++ code to get the datasource: static void main(Args args) { EmplDuplication EmplDuplication; EmplTable localEmplTable; ; if(args.record().TableId == tablenum(EmplTable)) localEmplTable = args.record(); ... }

İsmail Ozcan

Search This Blog