AX 2012 SSRS Report Development - Part 2

AX 2012 SSRS Report Development - Part 2

SSRS report in Visual studio

Open Visual Studio, click on File -> New Project. New Project dialog is open as shown below:

Now let us add a new report to the newly created report Model as shown below. Right click on the Project from the solution explorer, Add >> Report

Give the Proper Name to the Report and these are the following nodes.

The purpose of each report Node is described below:

Ø  Datasets: The report dataset retrieves data from the AX, We can retrieve the data from the following ways.

Create new data set and go to Properties

§  Query                            

     Data get from AX Query

§  Business Logic                          

     Data get from C# Business Logic

§  Report data provider (RDP).       

    Data get from AX Tmp Tables through DP Classes

§  AX Enum Provider

Ø  Designs: The design or layout of the report on which the data would be displayed after retrieving from AX. There are two types of report designs available in SSRS report ,There are two types of report designs available in SSRS report

§   Auto Design:        It will automatically set design for the Dataset.

§  Precision Design.  we will use for a custom placement of fields in a report and complex report designs.

Ø  Images: Any embedded images that you want to display on SSRS report.

Ø  Data Methods: Business logic written in C#. Data methods are useful to Link Action to open the AX Form.

Ø  Parameters: Report parameters which are to be displayed on SSRS report and user can filter the report based on those parameters.