C# Code Sample: Creating an Excel 2007 XML File from a DataTable object

Recently I’ve been playing with System.Data.DataTable and needed to generate an Excel Spreadsheet from from records stored in a DataTable (CSV format wasn’t sufficient for my needs). The sample below uses the ExcelXmlWriter library from Carlos Aguilar Mares which makes this very straightforward.   The ExportToExcelXml method creates the Xml File. The ExportToExcel method will…


Dynamics AX 2009: Preparing Role Center Deployment

BACKGROUND Dynamics AX 2009 is a huge project and when I describe the value it delivers I always make sure I mention that to achieve that full value, a customer should be using Role Centers. And just for reference here is one of the Role Centers – the CEO Role Center. You can learn more…


Consuming Extension Methods in IronPython

[Update on 2008-01-06] I’ve modified the post to reflect the information Dino provided. It turns out the SpecialName attribute is not required on extension methods but only when you are defining normal extension methods only when defining new operators.   One of my projects implemented in C# makes frequent use of extension methods. Recently I…


Dynamics AX 2009: Creating an SSRS 2008 report that gets data from an AX Cube

Very soon you’ll be able to use Dynamics AX 2009 BI Components with SQL Server 2008. One benefit of SQL 2008 is that SSRS 2008 includes a new tool to design reports called SQL Report Builder 2.0. You can use Report Builder 2.0 to design ad-hoc reports against the OLTP database or reports against the…


Dynamics AX 2009: Launching an SSRS report from the Dynamics AX client UI

In my previous post I showed how to create and deploy report. At that time I just manually browsed the SSRS website to find the report. However, the typical way a user will launch a report is from the AX client (or from the AX Enterprise Portal web site) In this example, I’ll show how…


Dynamics AX 2009: Creating a simple SSRS Report

Dynamics AX 2009 features support for writing reports using SQL Server Reporting Services. In this post, I’m going to show you how to create a simple SSRS report that accesses data in the AX database. The overall process I will describe will focus on the first stage of authoring and deploying the report from the…


.NET Framework Setup Verification Tool User’s Guide

.NET Framework Setup Verification Tool User’s Guide Introduction This .NET Framework setup verification tool is designed to automatically perform a set of steps to verify the installation state of one or more versions of the .NET Framework on a computer.  It will verify the presence of files, directories, registry keys and values for the .NET…


Dynamics AX 2009: BI/Reporting/Analysis on SQL Server 2008, and Windows Server 2008

If you  have tried installing Dynamics AX 2009, you may have noticed that the Business Intelligence components (Reporting & Analysis components) have issues installing with Windows Server 2008 and SQL Server 2008. (Axel Kühn posts about his experience here). Does Dynamics AX 2009 support SQL Server 2008 and Windows Server 2008? Yes, and this support…