Consider the following scenario: - You have one Microsoft Dynamics AX 2012 AOS instance fully configured, and users are able to open reports from the AX client connecting to this instance. - You now add an additional AOS instance. - Users connecting to the additional/new AOS instance get the...

As mentioned in this blog http://technet.microsoft.com/en-us/library/hh389760.aspx it is possible to have multiple instances of Reporting Services on the same computer. This is meant in situations to support development and production installations of Microsoft Dynamics AX, or to support multiple production...

With Microsoft Dynamics AX 2009 we do not support the setup where we have several instances of SQL Reporting Services on the same box connecting to different AOS. The reporting extensions always made connection to AOS mentioned in current configuration taken from Dynamics AX 2009 Configuration Utility...

With Microsoft Dynamics AX 2009 we introduced the new Batch Framework with a lot of advantages compared to the Batch functionality of the former AX versions. But there was also one disatvantage: It was not possible to print reports or generate PDF files in batch processing if the reports contained images...

Recently we came across an issue with BarcodeCode128 barcodes - when using a tilde character (~) within a BarcodeCode128 barcode in AX the resulting barcode can be unreadable by scanners. The reason for this is that Code128 has three different code sets associated with it – using an escape character...

Thanks to our colleague in Japan we found problem when running some Dynamics AX reporting extensions report on SQL 2008 R2. When we open some standard SSRS reports with SQL2008R2 (ie. TSInvoicedPurchaseAmount.TS_InvoicedPurchaseAmountDetail.Report ), we receive following error. An error has occurred...

I run into this blog some time ago. It is lead by Saveen Reddy who is Product Manager for Dynamics AX Business Intelligence. On his blog you will find the bunch of screen cast which will help you to develop reports: http://blogs.msdn.com/b/dynamicsaxbi/archive/2010/12/01/ax-ssrs-reporting-screencast...

Recently we found an "Invalid Range" error to logged when using drill through on an AX SRS Report we created for a custom table following the documentation at the link below: "How to: Add a URL Drill Through Action" http://msdn.microsoft.com/en-US/library/cc582049.aspx From further investigation...

Lately we got some request regarding this subject. Unfortunately in current version the is no way to get it done automatically. The process as the cleaning cubes process is quite complex and manual. Although with help of team we managed to create attached draft document with step by step documentation...

I ran into this problem when running TS_DeliveryPerformance report which was simply empty. After investigation I saw that all packing slip transactions made in January 2011 were shown in Sales Cube under Unknown year. Going forward when I browse Time dimension I could see that dates are only generated...

Recently we were able to solve an issue with the print medium on certain reports. It is not changed immediately in a report print dialog option when it is generated from a class that extends RunBaseReportDialog . This works fine when printing a standard report without extending from the RunBaseReportDialog...

We run into this problem on environment when we uninstalled SQL 2005 Reporting services and installed SQL 2008 Reporting services instead. As needed I have applied one of hotfixes 959494 or 957312 and I wanted to install Dynamics AX reporting services according to Dynamics AX Installation Guide ....

Some time ago I needed to set up reporting role for Dynamics AX 4.0 with Turkish GLS and database which collation was Turkish_CI_AS. The task was not easy. Starting from situation that I was not even able to start AOS after installation when KB article: https://mbs.microsoft.com/knowledgebase/KBDisplay...

Some time ago I run into following problem. The date picker control in Dynamics AX 2009 SSRS reports used wrong date format (EN-US) while it should use NO (Norwegian). This concerned all AX 2009 SSRS reports, and viewing them from both Dynamics AX client and in Enterprise Portal. When viewing the report...

We recently came across an issue, that if you are using Microsoft SQL Server 2008 Reporting Services some charts in the Microsoft Dynamics AX 2009 Role Center have incorrect axis scale values on the Y-Axis. Instead of values from e. g. 0 to 1000 you only see 0-0-0-1-1-1 . For example the following...

Lately we run into strange problem. After changing data we would like to refresh Role Center page to see it in Dynamics Ax Reporting services report. Even those data were changed and we trie to refresh page (F5 or CTRL + F5) data in report is not refreshing. We were trying all possibilities like: refreshing...

When deploying the AX 2009 smmOpportunityReports using the Reports Deployment tool or directly from the AOT, you may get the following warning: One or more libraries built with warnings. Please see MSBuild log at C:\Users\ <your username> \AppData\Local\Temp\1\tmp98ED.tmp Deploying 1 data...

Some time ago we run into problem which did not let us deploy reporting extensions to SQL Reporting Services. Just after building libraries we got the error: [ThreadAbortException]: Thread was being aborted. at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously...

Some time ago we got question how to install AX 4.0 Reporting Role with SQL Server 2008. As every time when you are trying to install Reporting Services extension from AX 4.0 installation wizard, partner has got error: "SQL Server Reporting Services must be installed before a Microsoft Dynamics...

I was recently involved in a situation were the Reporting Library deployment from Dynamics AX 2009 to SQL Server 2008 Reporting Services was not working correctly. More concrete, after the Reporting Libraries were extracted, compiled and the deployment to the SSRS started, soon the following error was...

Some time ago I run into following question regarding reporting development in Visual Studio 2008 To add a query to AxQuery you pass in a Dictionary object, but our range needs to be equivalent to: select * from InventTrans where DatePhysical < _paramDate && (DateFinancial == datenull() |...

This issue only affects users of Windows Server 2008 R2. One of the pre-reqs for installing Role Centers and Enterprise Portal and/or Reporting Extensions or Workflows is that you must have IIS installed locally on the server. If this is not installed and/or is partially installed with some required...

Lately we run into following problem: when navigating to any SSRS report via Enterprise portal or even by the SSRS report manager site, the following error is displayed where the report should appear: An error has occurred during report processing. (rsProcessingAborted). The type initializer for 'System...

Recently we were having problems to get the Role Center up and running. Report Server is setup and working in a correct way. Most reports can be generated, but a few does not answer correct. For those report the following error is generated: “Query execution failed for data set 'Company'” Reports in...

We came across an issue recently where the Dynamics AX 2009 reporting extensions and sql reporting services reports deployed successfully. However when trying to browse and view ANY of the published reports on the SQL Reporting server or via role centers we get the following error displayed: Error...