Contact Me

Total Pageviews

Tuesday 17 June 2014

X++ Reports/AOT Reports [MorphX reporting Framework ] and Why SSRS ?

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 ;)

No comments:

Post a Comment