Rahul Sharma

Solutions Architect - Microsoft Dynamics AX | Azure

Blog
This is a technology blog covering Microsoft Dynamics AX, Microsoft Dynamics CRM, Microsoft Azure, IoT, .Net, SharePoint, SQL Server, SSRS, SSAS, SSIS, Apache Cassandra, MongoDB, and related technologies. Join this blog on facebook {Rahul Sharma}, to start a discussion !!! NOTE: My employer is not responsible for the content published here.

Index | MS Dynamics AX | MS Dynamics CRM
View blog as >> Magazine | Sidebar | Flipcard | Mosaic | Snapshot | Timeslide

Reporting Capabilities of MS Dynamics Ax 2009 - Part 3 (Visual Studio 2008 & SSRS)

This article is from a series of articles describing Dynamics AX reporting capabilities. In this article we will see how developers can create SQL Server Reporting Services (SSRS) reports using Dynamics AX and Visual Studio 2008.

Prerequisites:
You must have Dynamics AX Reporting tools installed on client from where you want to create and deploy report. You must also have access to the SSRS report server.
To know more about Dynamics AX installation requirement and procedure, follow this link... Microsoft Dynamics Ax 2009.

Before we see how to create Dynamics AX SSRS reports, lets make it clear in our mind that Dynamics AX model-based SSRS reports are actually a superset of standard SSRS reports. It means you have everything you see in standard SSRS plus more advanced reporting features if you are creating SSRS report based on Dynamics AX SSRS approach.

Get MS Dynamics Ax Call Stack in X++ Code

Sometimes it is really useful to know the Dynamics Ax call stack for debugging purposes. For example if you want to debug a scenario where user is doing something and getting weird results and you know which method is causing it but you are not sure when it is being called and moreover from which place in Dynamics Ax.

You can create a static method in Global / Info class or wherever you want and call it within the debugging method. When the method is called you will see a InfoLog about the call stack. Though this example shows you an InfoLog but you can use any destination for your output and optionally add time-stamp to it.

Reporting Capabilities of MS Dynamics Ax 2009 - Part 2 (SSRS Report Builder)

This article is from a series of articles describing Dynamics Ax reporting capabilities. In this article we will see how easily end user can create a Dynamics Ax SQL Server Reporting Services report using Report Builder (MorphX development tools) for Dynamics Ax.

Here developer also plays a role in the setup of ad hoc report. Using Report Builder, Microsoft SQL Server Reporting Service component, end user can create a transactional ad hoc report based on the transactional data entered in the Dynamics Ax.

In this article we will see how to create a simple report using report builder. In this scenario Dynamics Ax end user creates the report, and setup of report information is done by a developer and an administrator by creating perspectives and generating report models respectively.

Reporting Capabilities of MS Dynamics Ax 2009 - Part 1 (Ax Report Wizard)

In today's competitive markets, success depends on business intelligence information available to the end users (individuals, teams and executives). Dynamics Ax provides rich set of reporting capabilities for both end users and developers.

  End users can create ad hoc reports themselves in Dynamics Ax without any developer support. In ad hoc report, user selects the data to display on the report and designs the layout of the report. There are two ways to do it using Dynamics Ax MorphX development tools.
  1. Dynamics Ax Report Wizard: Provides a wizard to select step-by-step options to create a complete Dynamics Ax native report.
  2. SSRS Report Builder: User can create a more complex report based on an already created report model. User need not worry about the complexity of table structure and their relations.
  Developers can create more complex reports in following ways:
  1. MorphX report designer: Dynamics Ax native reports.
  2. SSRS Dynamics Ax Report Library using Visual Studio 2008.
  3. Gantt Chart Reporting (data analysis based on different kind of scheduling jobs).
This article is from a series of articles describing Dynamics Ax reporting capabilities. In this article we will see how easily end users can create Dynamics Ax report using MorphX development tools for Dynamics Ax.

Open SSRS reports (designed outside Dynamics Ax) in Dynamics Ax

Dynamics Ax provides rich set of reporting capabilities for both end users and developers.

By default Dynamics Ax does not support opening the SSRS reports (created through Report Builder or without using Dynamics Ax reporting tools) in Dynamics Ax itself, instead you can only view these reports on your browser by typing the full report web address.

So, here is the workaround to open SSRS reports in Dynamics Ax created through SSRS Report Builder or any other tool.
Note: It is assumed that you have already created the SSRS report through report builder from Dynamics Ax.

ActiveX Gantt Chart control in Dynamics Ax

This article exposes the very less used but two very important features; Gantt Chart Reporting (data analysis based on different kind of scheduling jobs) and use of ActiveX controls in Dynamics Ax. I hope you all understand what we can achieve through Gantt Charts. And ActiveX controls are small programs that provide add-on functionality to your application, usually it provides a GUI which can be placed on your forms / reports.

Note: This article is for advance Dynamics Ax users.

Dynamics Ax uses a third party ActiveX control to implement Gantt Charts. The ActiveX control is from NETRONIC, called VARCHART XGantt version 4.1.


So, for our Gantt Chart we will use this ActiveX, this way you will also understand "How to use third party ActiveX controls in Dynamics Ax?".

Ax 3.0 SP* to Ax 2009 SP1 Upgrade - Part 2 (data upgrade)

This article provides Ax technical consultants step by step procedure of executing Microsoft Dynamics Ax 3.0 to Microsoft Dynamics Ax 2009 SP1 upgrade. It also suggests some steps which can be followed for enhancing the upgrade performance.

I recommend get Ax at Ax 3.0 SP3 or Ax 4.0 level to start upgrade. Or If you have country specific DIS layer involved than you first need to take Ax to Ax 3.0 SP6 first as there might be issues of some db schema changes in different country specific DIS and some data upgrade scripts not included in Ax 2009 to handle DIS db schema changes below Ax 3.0 SP6. Identify cases where this situation exists and create an upgrade script to handle the situation automatically, or copy the data manually from the Ax 3.0 database to the Ax 2009 database after the upgrade.
Note: Not all the countries affected with this.

Upgrade
It is divided in two parts, Code Upgrade and Data Upgrade. You can do both these steps in one go but I will say go one by one, starting with code upgrade first and then moving to data upgrade.

Ax 3.0 SP* to Ax 2009 SP1 Upgrade - Part 1 (code upgrade)

This article provides Ax technical consultants step by step procedure of executing Microsoft Dynamics Ax 3.0 to Microsoft Dynamics Ax 2009 SP1 upgrade. It also suggests some steps which can be followed for enhancing the upgrade performance.

If you are on an Ax version older then Ax 3.0 than you first need to upgrade Ax to Ax 3.0 / 4.0 only than you can take it directly to Ax 2009 / Ax 2009 SP1.

I recommend get Ax at Ax 3.0 SP3 or Ax 4.0 level to start upgrade. Or If you have country specific DIS layer involved than you first need to take Ax to Ax 3.0 SP6 first as there might be issues of some db schema changes in different country specific DIS and some data upgrade scripts not included in Ax 2009 to handle DIS db schema changes below Ax 3.0 SP6.
Note: Not all the countries affected with this.

Although this article describes Ax 3.0 to Ax 2009 SP1 upgrade path but you can also find it useful if you upgrading from Ax 4.0 to Ax 2009 SP1. The procedure for upgrading from Ax 3.0 and from Ax 4.0 differ primarily in the amount of preparation required for data upgrade. Upgrading from Ax 3.0 requires additional steps.

My Last Day at Tectura, India

As many of you probably know, today is my last day. But before I leave, I wanted to take this opportunity to let you know what a great and distinct pleasure it has been to type "Today is my last day."

When I started to think what to write here, the first thing came into my mind is why I am calling it last working day... Hmmm... But I think rather than saying "my last working day at Tectura", I would say, "going on long vacation"... who knows if we meet again and I might have more things to share with you all from my new challenging and excited role in New York, US. ;)

Call your Ax customization from Visual Studio C# code

How about calling your Axapta customizations (Classes / Class & Table methods / Enums) from your EP User control?

For this you need your X++ code resources available for use in Visual Studio. A proxy can do it for you. Ax already has this proxy defined for you as Proxies static file that is maintained in the AOT. You need to add references for your classes, methods or enums that you want to access from User Controls to this existing proxy.

Create a popup window to show custom html on Axapta EP

In this post we will create a custom popup window to show your HTML stuff when you click on a lookup button. After reading this post, you can compose any type of HTML and should be good  to display this on your Ax EP Lookup like browser window.

Tested on: Ax 4.0

Let's jump right on the development without wasting any more time. In my example I will use this popup window to show Item Image. The item image Url is saved in the ItemTable.
You can create any HTML.

MS Dynamics Ax 2009 EP Development - Part 1

This article is for understanding what's going on behind the scene when you want to do Microsoft Dynamics Ax 2009 Enterprise Portal (EP) customization. This article also explains how to start with the EP development using Visual Studio 2008 (recommended method of doing all new EP development).

Basic:
When you customize EP or do new development, you perform actions on Windows SharePoint Services, AOT & Visual Studio.

EP can be used with WSS or with MOSS. Basic tasks of customization & development like creating new pages or adding Web parts to existing pages are all performed directly in Windows SharePoint Services.
The resources for EP are stored in the AOT. Some development tasks are performed directly in the AOT, such as defining data sets, business logic, security, site structure, and navigation for EP.

Stick to it for success!!!

"Many of life's failures are people who did not realize how close they were to success when they gave up."

"Sometimes, all you need to invent something is a good imagination and a pile of junk..."

- Thomas A. Edison  

Speech On Late Sitting!!!

Infosys’ Chairman and Chief Mentor Officer (CMO) – Mr. Narayana Murthy’s Speech on Late Sitting in Office:

I know people who work 12 hours a day, six days a week, or more. Some people do so because of a work emergency where the long hours are only temporary. Other people I know have put in these hours for years. I don't know if they are working all these hours, but I do know they are in the office this long. Others put in long office hours because they are addicted to the workplace. Whatever the reason for putting in overtime, working long hours over the long term is harmful to the person and to the organization.