SSRS Reports in D365 FnO

 

SSRS Reports

 

SSRS (SQL Server reporting services) - SSRS provides a tools and services to help you to create, deploy, and manage reports for your organization. By this programming features that enable you to extend and customize your reporting functionality.
It is a report generation software that is a part of Microsoft SQL Server.
It enables users to execute reports using a web interface or even as embedded reports in applications
by using a web services interface

 

 

Report Type & Designs

Report Types: In AX there are two types of Reports

·       Query Report

·       RDP Report

Query Report: We can create reports using AOT Query (static query). This approach is suggested when data is coming direct from tables.

RDP Report: RDP report involves business logic according to the requirement.  This logic may be calculations or getting values from different tables based on conditions.


Report Designs: Reports in AX are used to display data to users in a format which is suitable for the way that the information is read.
A report can have multiple designs so that the code can decide at run-time which design to use. The designs can be totally different, but they would share the same data sources and form methods.

There are two common design patterns

·       Auto Design

·       Precision Design

Auto Design: This report is automatically generated based on the query in the data sources of the report. It limits the possibilities for the developer as developer cannot make any changes in the design of report.

 

Precision Design: The developer has full control over the design, he can modify the design according to the requirement.

 

 

Report Nodes:

The purpose of each report items is described below:

·       Datasets: The report dataset retrieves data from the AOT query. All fields which are available in AOT query are shown in the report dataset which can be referred in the report design later on.

·       Designs: The design or layout of the report on which the data would be displayed after retrieving from AX.

·       Images: Any embedded images that you want to display on SSRS report.

·       Parameters: Report parameters which are to be displayed on SSRS report and user can filter the report based on those parameters.