Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Field List (Web)

  • 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-designer-field-list

#Manage Report Data Sources

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

web-designer-field-list-data-source-actions

Element Description
web-designer-field-list-add-data-source-button Invokes the Data Source Wizard that allows you to select a data source from the list of predefined data sources, or add a new data source. The Wizard assigns the selected or a 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).
web-designer-field-list-data-source-search Allows the user to enter text to filter queries and fields in the field list.
web-designer-field-list-data-source-rename Allows the user to rename the data source.
web-designer-field-list-data-source-rebuild Allows the user to rebuild the result schema.
web-designer-field-list-data-source-edit-relationships Invokes the Master-Detail Relation Editor.
web-designer-field-list-data-source-add-calculated-field Adds a new calculated field to the data source.
web-designer-field-list-data-source-add-query Invokes the Create a Query or Select a Stored Procedure wizard page.
web-designer-field-list-data-source-delete 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

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-designer-field-list-query-actions

Element Description
web-designer-field-list-data-source-edit-relationships Invokes the Create a Query or Select a Stored Procedure wizard page.
web-designer-field-list-data-source-add-calculated-field Adds a new calculated field to the query.
web-designer-field-list-data-source-delete 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

#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.

web-designer-field-list-create-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.

web-designer-field-list-drop-multiple-controls

<!– 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.

web-designer-field-list-drop-field-headers –>

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.

web-designer-field-list-bind-existing-control

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-designer-field-list-report-parameters

The following actions are available for parameters:

Button Description
web-designer-report-wizard-button-query-add Invokes the Add Parameter dialog.
web-designer-field-list-data-source-delete Removes the selected parameter.
web-designer-field-list-data-source-edit-relationships 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

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