Progress® Telerik® Reporting R3 2017

Connecting to Data

The topics in this section describe how to connect Telerik Reports to data, filter, order, group data, and create expressions that when evaluated at runtime will customize the content and appearance of your reports.

Data Source Components

  • Data Source components are used to connect data items to different types of data without writing any code.

  • Most of the Data Source components allow working with data source parameters which are used to filter the data on retrieval. Data source parameters can be mapped to report parameters, data fields or to the result of the expression.

  • Data source components allow adding calculated fields in order to create new values that do not exist in the data source.

For more details see topics in Data Source Components section.

Data Items

  • Data items are used to display the data in reports and set filtering, ordering and grouping rules that are applied over this data.

  • The most straightforward approach for connecting a data item to data is to set data item's DataSource property to a Data Source component. In master-detail scenarios, data item can be connected to the parent's data as well.

For more details see topics in Data Items section.

Expressions

  • Expressions are widely used while designing reports in order to manipulate report's data, style and behavior. When the report runs, the report processor evaluates the expressions using built-in scripting language and substitutes the property values where expressions were used with the result of the expression. Examples of expression usage: grouping, sorting, filtering operations, properties of the report and report items(sections), bindings, conditional formatting, report parameters etc.

  • There are built-in functions which allow to perform complex calculations in expressions. Users confident with any of the .NET languages can extend the expression engine in order to use custom functions in their reports.

For more details see topics in Expressions section.

Report Parameters

  • The most common usage of report parameters is in the data-retrieval method which is one of the ways to improve the report's performance. Report parameters are also commonly used in properties of the report or report items(sections), grouping, sorting, filtering operations etc.

  • Referencing report parameters inside expressions can be achieved with Parameters global object which at runtme will be replaced with the actual value of report parameter.

For more details see topics in Report Parameters section.