Skip to main content

Dynamics AX in the Field

Have you installed one of the new Report Builders-- version 2 or version 3-- and can't get AX to launch it?
This posting addresses the issue and walks you through the steps to point AX to the new version.
The first step is that you will need to get Report Builder 2.0 or 3.0 installed on your report server. You should be able to access the Report Builder through the Internet Explorer first. In addition, you should already be able to access Report Builder 1.0 from AX. If you don't have this working you will need to revisit the installation guides. Once you have Report Builder 1.0 working through AX and the newer version of Report Builder working outside of AX than you can make the following changes.
Try this in a Test Environment prior to performing this on a production environment and as always make sure you have good backups.
Get into Dynamics AX and access the AOT.
1) Locate the SRSConfiguration class (Classes >>SRSConfiguration).
2) Edit the getReportBuilderUrl method with the following changes:

3) Save the method.
4) Locate the SRSReportBuilder class (Classes >> SRSReportBuilder).
5) Edit the Invoke method to have the following changes:

6) Save the Method.
7) Compile the changes and test.
To learn more about Report Builder and the features each version offers, visit SQL 2008 R2 site here.
Keep in mind that not all features of Report Builder 2.0 or 3.0 may not work with AX 2009. The code changes above are considered code suggestions and qualify as a customization and may not be supported under support agreements.

Popular posts from this blog

What does this mean: "The form datasource query object does not support changing its AllowCrossCompany property after the form has executed the query."?

I have made a form with datasources vendtable and vendtrans. Inside vendtable_ds.executequery() looks like this: QueryBuildDataSource queryBuildDatasource ,queryBDS_VendTrans_Invoice; ; queryBuildDatasource = this.query().dataSourceTable(tablenum(vendtable)); queryBDS_VendTrans_Invoice = this.query().dataSourceTable(tablenum(vendtrans)); if (curext() == "MASTERCOMP") { this.query().allowCrossCompany(true); } else { this.query().allowCrossCompany(false); } //FilterVendorName = stringedit control on form if (FilterVendorName.text()) { queryBuildDatasource.addRange(fieldNum(VendTable,Name)).value(strfmt("*%1*", FilterVendorName.text())); } else { queryBuildDatasource.clearRange(fieldNum(VendTable,Name)); } //FilterInvoiceNumber = stringedit control on form if (FilterInvoiceNumber.valueStr() == "") { queryBDS_VendTrans_Invoice.enabled(false); } else { queryBDS_VendTrans_Invoice.enabled(true); queryBDS_VendTrans_In...

Credit Note [Dynamics AX] using X++

This post will help to create credit note for a sales order based on the invent lot id. All the invoices raised for a particular sales line – Lot Id will be raised back as a credit note. Information on Credit Note: A credit note or credit memorandum (memo) is a commercial document issued by a seller to a buyer. The seller usually issues a Credit Memo for the same or lower amount than the invoice, and then repays the money to the buyer or sets it off against a balance due from other transactions Below Code will help to create credit note for all the invoices raised against the sales line -lot id. Please note: This code can be customized as per your requirements. This is just a template to help creating credit note using X++ code. Please test the code before use. static void SR_CreateCreditNote_Sales(Args _args) { // Coded by Sreenath Reddy CustInvoiceTrans custInvoiceTrans; Dialog dialog = new Dialog(“Create credit note – for sales.”); DialogField dfInv...