Display Values from a Database (Bind Report Elements to Data)

Reporting User Guide

Report Editing Basics : Display Values from a Database (Bind Report Elements to Data)

Report elements can display dynamic data from a bound database. For example, an employee list report may need to display birth dates. If a database contains this information, it can easily be added to the report using one of the methods described below.

Databound elements are indicated in the Reporting by a yellow database icon in their top-right corners.

Use Field List

•

To bind an existing report element to database data, click the required field item in the Field List window, and then drag and drop it onto the element. The yellow database icon inside the control will then appear.

•

To add a new data-bound report element, drag the required field item from the Field List window onto a report band. This will create a Label bound to the selected data field.

•

A more flexible way to create data-bound elements is to right-click a Field List item, and then drag and drop it onto a report. This will display the context menu shown in the image below. Choose the element type that will represent the data, and it will be automatically created and bound to the selected data field.

Use Smart Tag

Click an element's Smart Tag, and in the displayed menu, expand the Data Binding drop‑down list and select the required data field.

Use Property Grid

Click an element to show its properties in the Property Grid. Expand the Data Bindings branch that holds the bindable attributes. Specify a data field for the required attribute (e.g. Text).