SSRS:How to create SSRS Reports using AOT Query & Auto design in Ax 2012

OverView:

There are multiple ways to develop SSRS reports in Dynamics AX. This tutorial will guide you through the process of developing SSRS reports using an AOT query and auto design.

Pre-requisites

1. Microsoft Dynamics AX 2012
2. Visual studio 2012
3. SQL Server report server must be configured
4. Reporting services extensions must be installed in Dynamics AX

Steps

1. First of all we need an AOT query which will fetch data from AX and display it in a report. For this tutorial, I am using an existing query in AX which displays a list of customers.
2. CustTableListPage query will be used in this tutorial. To find this query, open AOT àQueriesàCustTableListPage.
3. The development of the SSRS report is done in Visual studio. So a new project needs to be created in Visual studio.
4. Open Visual studio. Go to File à New à Project.
5. In the section Installed templates select Microsoft Dynamics AX and then select Report Model in the right pane. Name the project “QueryBasedDemo“. Press OK.
   

   
   

SSRS Tip: Creating Multiple Data Regions In SSRS Reports

Hi Friends,

Today i'll demonstrate how to create multiple data regions/ groups in SSRS reports. A data region in simple definition is a subreport report that shares the parameters and datasets, and is present inside the report design itself. 

• This and the following procedure will help you understand how multiple data regions can be created in SSRS. The first of the two data regions will display the detailed customer transactions.

Note: 1. 1st we have to create a query using CustTrans and CustTable tables and with following fields as shown below.

           2. We are using "AutoDesign" report while creating reports.  

• Create a PktCustTransList query, which includes the CustTable and CustTrans tables. Remove the unwanted fields and retain only the fields that are shown in the following screenshot:

• Open Visual Studio and create a new Report Model Project named PktCustTransReport and create a dataset that refers to the PktCustTransList query.

• When selecting the fields in the query window, select all the fields and the name data method from CustTable.

SSRS Tips: How To Get GrandTotal Using Autodesign in SSRS Report

Procedure:  3 Simple & Easy Step's

1. Open Property Window Of AutoDesign Node In Your Report.

2. Set The "GrandTotal" Property To "Yes".

3.That's it , It will Take care of the printing the total .

Proud To Be a DAX Developer  :-)