Create SSRS report in AX 2012

Reports in Microsoft Dynamics Ax 2012 are based on SQL Server reporting services (SSRS)
SSRS

Before designing and executing the Report, SSRS needs to be configured.

We can use a Query as a datasource or use report data provider class.

1. Using a query as datasource :

—  Create a new query in AOT TestQuery with required datasource

—  Open visual studio and create a new Dynamics AX project

— Select Microsoft Dynamics AX from the installed templates -> report model and name the model

— Add a new report to the newly created report Model as shown below

— Then add the dataset to the newly created report.
Right click on the datasets node and chose the option New datset
Set the Query property to the newly created query.
Then you can select the desired list of fields.
—  Under the design section you can create 2 types of design, auto design and precision design
—  Auto design arranges the fields and layout automatically whereas in precision we can customize the       design
—  Select the dataset and drag and drop on to your designs node it creates an auto design
Under the design node we can select multiple properties to control the report preview

—  After completing the above steps rt. click on report model and select add to AOT property to deploy      the report

—  When we come back to Ax the report can be seen in below path
AOT ->  Visual studio projects -> Dynamics AX Model projects
AOT ->  SSRS Reports -> Reports

—  After this we can create a output menu item and select the newly created report in the properties.
to execute the report

2. Using Report data provider.
–> For this first we need a temp table to store the report data and create required fields.
–> It is best to decide on the fields of table before starting the design of the report in

–> For the table set the property createTransactionId as Yes. This will be useful in the processing/ clearing of report data
visualstudio designer
–> Once the table is completed we need to create controller, contract and data provider classes

More on these classe in below link

https://dynamicsaxworld.wordpress.com/2014/05/20/report-data-providers/
–> After this a new Dynamics Ax model project can be created in visual studio and a new
report              can be added as in the above section.
–> When adding the dataset to the report set the newly created data provider class
–> Under the design node you can select a new precison design and start designing the report
based   on your requirement
–> After completing the above steps rt. click on report model and select add to AOT property to
deploy      the report