AX 2012: Create SSRS Line Chart Report

  Purpose: The purpose of this document is to demonstrate how we can leverage the power of business intelligence through a simple SSRS line chart report. Prerequisites: Visual Studio 2013 Visual Studio 2013 tools. Reporting extension. Report Builder. Should be well-versed in Report Programming Model. Business requirement: Leverage business intelligence by analyzing sales trends for top item groups … Continue reading AX 2012: Create SSRS Line Chart Report

Advertisements

AX 2012: Print SSRS Report in PDF to Disk

Purpose: The purpose of this document is to illustrate how we can print an SSRS report in PDF format to disk or file-system in X++. Business requirement: Ability to print an SSRS report in PDF format to disk or file-system automatically. Assumptions: SSRS report is successfully deployed to the report server. Development: Please find below the job … Continue reading AX 2012: Print SSRS Report in PDF to Disk

AX 2012: Create SSRS Column Chart Report

Purpose: The purpose of this document is to demonstrate how to develop SSRS column chart report in Dynamics AX 2012. Prerequisites: Visual Studio 2010 Visual Studio tools. Reporting extension. Report Builder. Should be well-versed in Report Programming Model. Business Requirement: Create a column chart report to show top products sold in the year 2012. Project … Continue reading AX 2012: Create SSRS Column Chart Report

AX 2012: SSRS Report Drill Through Action URL

In this post we'll learn how to add a drill through action URL to a field in an SSRS report. The focus will be more towards exploring drill through action URL rather than developing SSRS report. We'll be using an RDP report with precision design to demonstrate the development. Let's say we have a requirement … Continue reading AX 2012: SSRS Report Drill Through Action URL

AX 2012: Multi-Select Lookup for SSRS Report Dialog

Overview: In this post we'll learn how to build multi-select lookup for SSRS report dialog. We'll create an RDP report with an AutoDesign layout. Controller will be used to run the report. An output menu item will be created to point to the controller class. Each AOT element involved will be described in detail. You … Continue reading AX 2012: Multi-Select Lookup for SSRS Report Dialog

AX 2012: Add Report Parameter to SSRS Query Report

In this post we'll learn how to add report parameter and show it in the report dialog for a Query based SSRS report. Please follow the development steps below to achieve it: 1. Create an AOT Query MAKCustTable. 2. Drag CustTable table to the Data Sources node of the query. 3. Set Dynamic property to … Continue reading AX 2012: Add Report Parameter to SSRS Query Report

AX 2012: Chart in SSRS Report

Prerequisites: 1. Reporting services extensions must be installed 2. Visual Studio tools must be installed 3. Dynamics AX should be connected to Reporting services instance In this post we'll learn how to create data visualization in SSRS report using Pie or Doughnut chart. We'll be creating a query based AutoDesign report. This is how our report will … Continue reading AX 2012: Chart in SSRS Report