Opening a Report on AX 2012 raises infolog error: The default Report Server Configuration ID could not be found in the SRSServers table.

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 following infolog error when trying to…

0

Microsoft Dynamics AX 2012 Reporting Services – Scale-out deployments

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 installations of Microsoft Dynamics AX. When there are different instances of Reporting Services for AX2012…

0

Microsoft Dynamics AX 2012: Install multiple instances of Reporting Services extensions on the same machine

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. There is no way to change it. The…

0

You cannot print images on batch reports in AX2009? - Now you can !!

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. This issue has now been…

0

BarcodeCode128 and Tilde Character

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 in the barcode string to…

0

Some reports from Reporting extensions can raise error when running on SQL 2008 R2

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 during report processing. (rsProcessingAborted) Query execution failed for dataset ‘InvoiceAmountDetailedReport’. (rsErrorExecutingCommand) Query (58, 19)…

0

Dynamics AX Business Intelligence blog

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-list.aspx as well some sneak previews regarding Dynamics AX 2012 and BI. Blog: http://blogs.msdn.com/b/dynamicsaxbi/…

0

Documentation "How to: Add a URL Drill Through Action" confusing

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 we found the the hardcoded 1 at indexFields.Add method from the code…

1

How to add financial dimension to Dynamics AX Default cubes

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 how to add financial dimension…

5

OLAP Time dimension does not contain dates for year 2011

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 till the end of 2010 year. …

2