Finally I have sometime on hand that I can use to continue my posts on Reporting framework. I have not been able to update my blog due to various reasons but lets get started again.
In my previous posts I had covered about reporting framework terminologies and reporting project. In this post, let us go through the types of designs available for reports and different controls that are available for a report. Together all these elements form Report Model Elements
The first and foremost model element is the “Report” element itself
Report: The report element represents a report definition. A report definition contains a collection of elements such as datasets, parameters, images, and report designs.
The elements that define a report are located under the node for the report in a model. The report in turn contains Report Designs and Report Controls. A report element can be identified by following symbol:
Dynamics AX SSRS reports contains two types of report designs
- Precision Design
- Auto Design
A precision design is a report design that is created by using SQL Report Designer (Standard SSRS Report Designer). Precision designs are useful when a very precise layout is required.
An auto design is a report design that is automatically generated based on the report data. An auto design is created by using drag-and-drop actions, and selecting elements by using Model Editor.
You cannot have specific formats in the Auto Design. This design is useful mostly for tabular and matrix type reports with simple groupings and sorting. You can identify a precision design by the following symbol:
The report element can have following report controls or elements
- Data Region
- Data Method
A dataset identifies data that is displayed in a report. Every report must have one or more datasets. Default data sources that are available for Datasets are “Dynamics AX” and “DynamicsAXOLAP”. The data sets can have data fetched by using anyone of the following options:
- A query (Dynamics AX AOT query or an OLAP MDX Expression)
- Report Data Provider
- Business Logic (C# Business Logic with the reporting project only)
- AX Enum Provider (Enum values)
A data region is an area in a report that displays data. Data can be displayed in following formats
- Table – Data displayed in columns and rows. Symbol:
- Matrix – Data displayed in matrix format. Symbol:
- List – Data displayed in list format. Symbol:
- Pie Or Doughnut Chart – A chart type report. Symbol:
- XY Chart – A chart type reports (Bars, Columns, Lines on XY axis). Symbol:
Please note that all these data regions are available in Auto Design report only. The Precision Design has its own standard SSRS report controls.
A parameter lets you parameterize data for a report. With the help of parameters, you can filter the data to the required values.
A filter is used to filter or restrict the data that is displayed in a report.The Dynamics Filter property on the dataset determines how filters are created for a report. If the Dynamics Filters property on the dataset is set to True, the end user of the report will identify the ranges when they view the report. To manually define the set ranges to filter data on a report, verify the Dynamics Filters property on the dataset is set to False and create your own filters.
A grouping lets you organize data that displays in a report by grouping fields. For Auto Design, you can see a node called grouping for Table or Matrix type data regions. Groupings in Precision Design follow the same procedure that is used in Standard SSRS Reports.
A sort lets you control the order in which data displays in a report. For example, you can sort alphabetically by field in ascending or descending order.
A data method contains code to retrieve and process data for a report. The code for a data method is written in C# or Visual Basic, depending on which project template is used.
A layout template specifies the styles that are applied to the header, footer, and body of a report. One layout template can be applied to many reports. Layout Templates are created in a reporting project and are separate from Report Controls.
There are default layout templates available but we can define our own custom templates to suit the needs of the customers.
A style template specifies the styles that are applied to a data region. When you create a style template, you will notice that there are several types of templates that you can create based on the data region type. A style template can be applied to more than one data region in a report, and it can be applied to data regions in more than one report.
Following are the style templates that you can create (1 per data region type)
Report Data Sources
A data source is a source of data for a report dataset. You can use the predefined data source, which connects to the Microsoft Dynamics AX application database. Or, you can define your own data sources. System by default provides data sources for “Dynamics AX” and “DynamicsAXOLAP”.
This concludes the report designs and controls.