Skip to main content

Field List

  • 4 minutes to read

This document describes the Field List panel that enables a user to explore and manage report data sources and parameters. The user can drag fields from the field list and drop them onto the design surface to create bound report controls.

The Field List displays data sources available for the report. The displayed data sources belong to the report and get serialized with the report.

Web Report Designer - Field List Panel

Manage Report Data Sources

The following actions allow the user to add, modify, and delete the report’s data sources:

Web Report Designer - Data Source Actions in the Field List

Element Description
Add Data Source Button Opens the Data Source Wizard, where you can select a data source from the list of predefined data sources or add a new one. The wizard assigns the selected or newly created data source to the report. For more information on predefined data sources, review the following help topics: Register Predefined Data Sources (ASP.NET Core), Register Predefined Data Sources (ASP.NET MVC).
Search Box for Data Sources Allows the user to enter text to filter queries and fields in the field list.
Rename Data Source Button Allows the user to rename the data source.
Rebuild Schema Button Allows the user to rebuild the result schema.
Edit Relationships Button Invokes the Master-Detail Relation Editor.
Add Calculated Field Button Adds a new calculated field to the data source.
Add Query Button Invokes the Create a Query or Select a Stored Procedure wizard page.
Delete Data Source Button Removes the selected data source.

You can also right-click a data source to access these actions in a context menu:

Web Report Designer - Context Menu for Data Sources in the Field List

Use the ReportDesignerDataSourceSettings to hide UI elements from the user:

AllowAddDataSource
Hides the Add Data Source button in the Field List and the Add Data Source menu command.
AllowEditDataSource
Hides UI elements that allow the user to edit the data source and queries in the Field List.
AllowRemoveDataSource
Hides the UI element that allows a user to remove the data source from the Web End-User Report Designer in the Field List.

Manage Queries

The following actions allow the user to add, modify, and delete queries:

Web Report Designer - Query Actions in the Field List

Element Description
Edit Query Button Invokes the Create a Query or Select a Stored Procedure wizard page.
Add Calculated Field to Query Button Adds a new calculated field to the query.
Delete Query Button Removes the selected query.

You can also access these actions in a context menu. Right-click a query to open a context menu:

Web Report Designer - Context Menu for Queries in the Field List

Create Bound Report Elements

The Field List allows you to create new bound report controls and bind existing controls to data.

Add a new data-bound report control

Drag the data field from the Field List to a report band in the design area. This action creates a reporting control bound to the selected field. The type of the created control depends on the data field type.

Dragging a field to create a bound control

Add a new data-bound table

Select multiple data fields in the Field List. To do this, click them while holding down the Ctrl or Shift key. When you drag the fields and drop them onto the report design area, a Table control is created with cells bound to selected data fields.

Dragging multiple fields to create a table

Add a new table with data field names

Select multiple data fields, a query, or a table in the Field List. Hold Shift when you drag the fields and drop them onto the report design area. The Report Designer creates a table with data field names.

Creating a table with field names

Bind an existing report control to a data field

Click the data field in the Field List, and drag and drop the field onto the control.

Binding an existing control to a data field

Tip

When a table cell is selected on the design surface, you can press Esc to move one level up and select the entire row.

Manage Report Parameters

Expand the Parameters node to access the collection of report parameters:

Web Report Designer - Parameters Node in the Field List

The following actions are available for parameters:

Button Description
Add Parameter Button Invokes the Add Parameter dialog.
Delete Parameter Button Removes the selected parameter.
Edit Parameter Button Invokes the Edit Parameter dialog.

You can also right-click a parameter to access these actions in a context menu:

Web Report Designer - Context Menu for Parameters in the Field List

For more information on report parameters, review the following help topic: Use Report Parameters.