Transcript Slide 1

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.
• Web Based Reports.
• Web Based Reports.
• Multiple Data Source.
• Web Based Reports.
• Multiple Data Source.
• Viewing your Reports trough a portal like share point.
• Web Based Reports.
• Multiple Data Source.
• Viewing your Reports trough a portal like share point.
• Easy design and deploy your report.
• 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.
• 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.
• 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.
Dynamic AX 6 will use Reporting service has his default report
designer.
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
• 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.
Go to you “Dynamic Ax” and Create a new Query, The Query will be the
Data later used in our Report.
Visual Studio allows you to create a Dynamic AX reporting project ,
when creating a new Visual Studio project use the
“Dynamic Ax Reporting Project”.
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.
Visual Studio lets you select , single filed
or result of the query or the table.
Visual Studio lets you select , single filed
or result of the query or the table.
After creating our new Dynamic AX data set
, we could view the different fields under
our new connection.
Use the Auto Design option in order to
Create a simple and quick design for 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
Lets have a quick preview of our Report
In order to keep with the same design Dynamic AX has, we will add
dynamic ax “Shared Library”
In order to keep with the same design Dynamic AX has, we will add
dynamic ax “Shared Library”
Add Shared Library as Reference to our project, this will let us to use
Dynamic AX “Shared Library”.
Adding the Shared Library as Reference lets us to use it as Style for the
Report Design and the Table Design.
Select the preview in order to see the Report.
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.
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.
Select the Report you wish to deploy.
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.
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
Open the Menu Item to view your new Report, and we have our first
Report from SQL Server Reporting Services