Designing using Reporting Server and Deploying it Using Dynamic AX

1. Designing using Reporting Server and Deploying it Using Dynamic AX

2. What is Reporting ?

3. What is Reporting ? SQL Server Reporting Services is a server-based reporting platform for creating reports from relational or multidimensional data sources. Reports are managed and viewed in a Web browser.

4. What is Reporting ?

5. What is Reporting ? • Web Based Reports.

6. What is Reporting ? • Web Based Reports. • Multiple Data Source.

7. What is Reporting ? • Web Based Reports. • Multiple Data Source. • Viewing your Reports trough a portal like share point.

8. What is Reporting ? • Web Based Reports. • Multiple Data Source. • Viewing your Reports trough a portal like share point. • Easy design and deploy your report.

9. What is Reporting ? • Web Based Reports. • Multiple Data Source. • Viewing your Reports trough a portal like share point. • Easy design and deploy your report. • Graphic Design like , tabular , pie and Graph.

10. What is Reporting ? • Web Based Reports. • Multiple Data Source. • Viewing your Reports trough a portal like share point. • Easy design and deploy your report. • Graphic Design like , tabular , pie and Graph. • Drill down trough your report data easily.

11. What is Reporting ? • Web Based Reports. • Multiple Data Source. • Viewing your Reports trough a portal like share point. • Easy design and deploy your report. • Graphic Design like , tabular , pie and Graph. • Drill down trough your report data easily. Did you know ? Dynamic AX 6 will use Reporting service has his default report designer.

12. Integration SQL Server Reporting Services is a server-based reporting platform for creating reports from relational or multidimensional data sources. Reports are managed and viewed in a Web browser. Microsoft Dynamics AX uses Reporting Services to create report models and to generate reports On one side we have dynamic ax on the other Reporting Server

13. Our Goals: • Accessing the Dynamic AX data Set from Reporting server . • Creating a Report using Reporting Server. • Deploying the Report from Dynamic AX . • Viewing the report using Dynamic AX Menus.

14. Create a Query Go to you “Dynamic Ax” and Create a new Query, The Query will be the Data later used in our Report.

15. Accessing Dynamic AX from Reporting Server Visual Studio allows you to create a Dynamic AX reporting project , when creating a new Visual Studio project use the “Dynamic Ax Reporting Project”.

16. Accessing Dynamic AX from Reporting Server Add a Dataset to the Report, Later on we will select the needed Query Easily use Visual Studio Dynamic AX project ,to select a table, Query from Microsoft Dynamic AX and add it into your report Dataset.

17. Retrieve the Need Data Visual Studio lets you select , single filed or result of the query or the table.

18. Retrieve the Need Data Visual Studio lets you select , single filed or result of the query or the table.

19. Retrieve the Need Data After creating our new Dynamic AX data set , we could view the different fields under our new connection.

20. Designing the Report Use the Auto Design option in order to Create a simple and quick design for the report.

21. Designing the Report Add a table into our design is a simple and elegant way to display your data. Easily drag the fields you wish into the Data of your table , in order to display them

22. Preview The Report Lets have a quick preview of our Report

23. Designing the Report In order to keep with the same design Dynamic AX has, we will add dynamic ax “Shared Library”

24. Designing the Report In order to keep with the same design Dynamic AX has, we will add dynamic ax “Shared Library”

25. Designing the Report Add Shared Library as Reference to our project, this will let us to use Dynamic AX “Shared Library”.

26. Designing the Report Adding the Shared Library as Reference lets us to use it as Style for the Report Design and the Table Design.

27. Preview the Report Select the preview in order to see the Report.

28. Accessing the report Using Dynamic AX Up until this point we have created the report using Microsoft Visual Studio ,Now we will see how simple it is to access our report from Microsoft Dynamic AX and make it part of our Dynamic AX. Before moving to Dynamic AX , we will need to save The Project to AOD using Microsoft Visual Studio , this lets us later on access the report from Microsoft Dynamic AX.

29. Accessing the report Using Dynamic AX Open Microsoft Dynamic AX , Go to the Application Object Tree(AOT) . In the AOT Click on “Report Libraries”. Select the Report Libraries which is needed to be deployed and then click on Deploy.

30. Accessing the report Using Dynamic AX Select the Report you wish to deploy.

31. Accessing the report Using Dynamic AX Select the Report you wish to deploy. When finished deploying a message will appear describing the success, failure ,errors and warning which might have happened when deployed the reports.

32. Creating a Menu Item Using the AOT we will add a new Menu Item ,Output Menu Item will be used in order to display our new deployed report. Object Type will be SQL Reporting Library Report. The object itself is our report which we just deployed

33. View The Report Open the Menu Item to view your new Report, and we have our first Report from SQL Server Reporting Services

34. כל הזכויות שמורות MAXIMUM ERP