Requesting Data From Controls

You can use the expression #<controlname>.value# to request data from any report page (for example, from a control that is placed on the same page of a report or from a control that is placed on a different page of the report). The expression can be added to captions or SQL statements of controls such as Labels or Data Sources. The expression tells the system to retrieve a value from a specific control and populate the current control with the data that is returned.

For example, if you add the following expression to a Label control, the system retrieves the TextBox1 value and populates the Label control with the data:


#TextBox1.value# 
      

From the above example, if TextBox1 contains the value Wendy, then Wendy appears in the Label control when the report is rendered.

DB Table

The DB Table represents a grid-like table that stores the database information that is retrieved by the data source, which, in turn, can point to one or more database tables.

In this example, the DB Table points to the data source, named dsEmployee. The DB Table has been named DBTableEmployee.



You can have more than one DB Table, but each DB Table can only point to one data source.

To display database information, the DB Table must contain field controls.