Tag Archives: SSRS

Receiving controlled parameters automatically in a SSRS report with Microsoft Dynamics Ax 2012.

When we want to print reports from a form and send filtered parameters using RDP (Report Data Provider) is advisable to use a controller class. This class allows catching the object from its path, thus avoid selecting the parameters manually.

Here we are going to show you how to do this:

Native SSRS withouth use the AX 2009 reported

For this blog, we are going to take the Payment Order example, in the clicked method, we instance the AwLaSSRSReportViewer class and the parameters send is done.

SSRS with Stored Procedures in AX 2009.

We are going to create a SSRS Report with stored procedures, in this example we will take the Ledger Journal Report.

Open SQL Management Studio

Edit an SSRS Report on ReportBuilder

First we need to enter our report folder using a web browser in this case our folder is located at win-i1sql75btid/Reports_MSSQLSERVER1. This will show the following window:

Pivots in SSRS

When we want to show a report grouped by a column, we used the following method.