The Field List displays the schema of a report's data sources. This panel enables you to manage report data sources and parameters, add calculated fields and create bound report controls.
Manage Report Data Sources
The Field List shows available report data sources and their structure.
The following actions are available in the Field List for data source customization:
Button |
Description |
|
Invokes a list of default data sources that you can add to a report. |
|
Removes the selected data source. |
|
Invokes the Master-Detail Relation Editor. |
|
Invokes the Create a Query or Select a Stored Procedure wizard page. |
The following actions are available for query customization:
Button |
Description |
|
Removes the selected query. |
|
Invokes the Create a Query or Select a Stored Procedure wizard page. |
Bind controls to data
Dropping a field onto a report's surface creates a new report control bound to a corresponding field.
Dropping a field onto an existing control binds this control to a corresponding field.
Create tables
Dropping an entire data table onto a report creates a table with its columns bound to fields contained in the data table.
To select multiple fields, click them with holding the CTRL or SHIFT key. Dropping these fields onto a report creates a new table with its cells bound to the corresponding fields.
Data shaping operations
In addition, the Field List can help you solve the following tasks:
•Add calculated fields to data columns for performing various calculations in a report.
•Manage the collection of report parameters.
