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.