Display values from a database

Use this procedure to display values from a database.

Report elements can either display static information or dynamic data fetched from the bound database. Data-bound elements are indicated in the Report Designer using a small database icon in the top-right corner.

Sometimes you may work with a report that is missing some information. For instance, you may have an employee list that does not display birth dates. If the database contains this information, you can easily add it to your report using one of the methods described below.

Use the Field List

  • To bind an existing report element, click the desired 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, simply drag the desired 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 invoke the context menu. Simply choose the element type that will represent your data, and it will be automatically created and bound to the selected data field.

Use the Property Grid

  1. Click an element's Smart tag.
  2. In the menu, expand the Data Binding list.
  3. Select the data field.

Use the Property Grid

  1. Click an element to show it's properties in the Property Grid.
  2. Expand the (Data Bindings) branch that holds the bindable attributes.
  3. Specify a data field for the required attribute (for example Text).