To justify the shift to SSRS, let's understand the drawbacks of the MorphX Reporting framework
1)It was a client side solution that means the framework needs to be installed in the client system.
It uses the capabilities of the client to print a report.
2)The system works only with tables in AX. It cannot be connected to an external database or a web service.
3)The reports cannot be exposed outside the AX client that means the report can only be viewed through the AX client.
4)The rendering reporting framework is very weak when it comes to graphical, tabular, and interactive reports.
AX 2009 versus AX 2012
SSRS has evolved as a mature framework for Dynamics AX. Here is a listing of the major
changes that came through the latest version in comparison to the previous version.
AX 2009 AX 2012
Used .Net business connector to communicate Uses the Dynamics AX services
to Dynamics AX framework (system services/
metadata services/document services) to dynamics Ax.
Control formats had to be defined explicitly Control formats are derived from
the corresponding types EDT/fields
Large data sets are first stored in a data table Data streaming is possible that
and then rendered causing a delay in loading enables data to be read in pages
of the reports or streams of data
Limited interactivity and no charting capabilities Rich charting and interactive
capabilities
Labels for each locale had to be created Standard AX labels can be
separately as a .resx file referenced and the framework
translates them according to the
locale
One report for each locale (English, Arabic, Only one report is created and is
and so on) was created rendered in different languages
Record-level security didn't apply to report data The entire security model (duties,
privileges, and XDS) is honored by
the reports
Deployed through the project deployment form. Uses PowerShell to deploy reports
No Cross reference for reports Reports are cross referenced
So,the SSRS reporting framework of Ax 2012 is more powerful and interactive than Ax 2009 SSRS reporting Framework.
That's it !
Happy Daxing ;)
1)It was a client side solution that means the framework needs to be installed in the client system.
It uses the capabilities of the client to print a report.
2)The system works only with tables in AX. It cannot be connected to an external database or a web service.
3)The reports cannot be exposed outside the AX client that means the report can only be viewed through the AX client.
4)The rendering reporting framework is very weak when it comes to graphical, tabular, and interactive reports.
AX 2009 versus AX 2012
SSRS has evolved as a mature framework for Dynamics AX. Here is a listing of the major
changes that came through the latest version in comparison to the previous version.
AX 2009 AX 2012
Used .Net business connector to communicate Uses the Dynamics AX services
to Dynamics AX framework (system services/
metadata services/document services) to dynamics Ax.
Control formats had to be defined explicitly Control formats are derived from
the corresponding types EDT/fields
Large data sets are first stored in a data table Data streaming is possible that
and then rendered causing a delay in loading enables data to be read in pages
of the reports or streams of data
Limited interactivity and no charting capabilities Rich charting and interactive
capabilities
Labels for each locale had to be created Standard AX labels can be
separately as a .resx file referenced and the framework
translates them according to the
locale
One report for each locale (English, Arabic, Only one report is created and is
and so on) was created rendered in different languages
Record-level security didn't apply to report data The entire security model (duties,
privileges, and XDS) is honored by
the reports
Deployed through the project deployment form. Uses PowerShell to deploy reports
No Cross reference for reports Reports are cross referenced
So,the SSRS reporting framework of Ax 2012 is more powerful and interactive than Ax 2009 SSRS reporting Framework.
That's it !
Happy Daxing ;)
No comments:
Post a Comment