[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Collapse]Reporting
 [Expand]Product Information
 [Expand]Getting Started with DevExpress Reporting
 [Expand]Creating Popular Reports
 [Expand]Detailed Guide to DevExpress Reporting
 [Collapse]Visual Studio Report Designer
  [Expand]Dock Panels and Designer Options
  [Collapse]Report Wizard
   [Collapse]Wizard Pages
     Choose a Report Type
     Empty Report
    [Collapse]Data-bound Report
     [Collapse]Connect to a Database
       Select a Data Connection
       Specify a Connection String
       Save the Connection String
       Create a Query or Select a Stored Procedure (Multi-Query Version)
       Create a Query or Select a Stored Procedure (Single-Query Version)
       Configure Query Parameters
     [Expand]Connect to an Entity Framework Data Source
     [Expand]Connect to an Object Data Source
     [Expand]Connect to an Excel Data Source
      Select the Data Source Type
      Choose Fields to Display in a Report (Multi-Query Version)
      Choose Fields to Display in a Report (Single-Query Version)
      Add Grouping Levels (Multi-Query Version)
      Add Grouping Levels (Single-Query Version)
      Specify Summary Options (Multi-Query Version)
      Specify Summary Options (Single-Query Version)
      Choose a Report Layout
      Choose a Report Style
      Set the Report Title
    [Expand]Template Report
    [Expand]Label Report
     Inherited Report
   Data Source Wizard
   Query Builder
 [Expand]Creating End-User Reporting Applications
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
This documentation page describes implementations made in our v17.2 release cycle. To learn about functionality shipping with v18.1, navigate to our updated help file experience at docs.devexpress.com. Learn More

Create a Query or Select a Stored Procedure (Multi-Query Version)

On this wizard page, you can choose which tables, views and/or stored procedures from your data source to display in the report.

Expanded Manage Custom Queries

When you are required to shape the query data at the level of a data source, you can create custom queries by expanding the Queries category and clicking the button. This will invoke the Query Builder where you can create complex queries by joining multiple tables, filtering, sorting and grouping their data, as well as calculating various aggregate functions.

The Query Builder can also be used to specify custom SQL. To learn more about using this option, see Ensuring Data Access Security.

To customize an existing query using the Query Builder, click the button.

To delete a query, click the button.

On finishing the wizard, each of the selected data items will be included into a separate query.

Expanded Specify Master-Detail Relationships

To define master-detail relationships between two or more queries, click Manage Relations.

To create a new relationship, connect the required key fields using drag and drop.

To edit an existing relationship, double-click the corresponding arrow or right-click it, and select the Edit Relation command in the invoked context menu.

This will invoke the Edit Relations editor that provides a different UI to manage the data relationships.

On finishing the wizard, the specified data relationships will appear in the Field List.


If selected queries or stored procedures contain any parameters, you will be required to define their values on the next wizard page: Configure Query Parameters.

Otherwise, clicking Next will open the next Report Wizard page: Choose Fields to Display in a Report (Multi-Query Version).

Expanded See Also

Is this topic helpful?​​​​​​​