[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]Get Started with DevExpress Reporting
 [Expand]Create Popular Reports
 [Expand]Detailed Guide to DevExpress Reporting
 [Expand]Visual Studio Report Designer
 [Collapse]Create End-User Reporting Applications
   Cross-Platform Reporting
  [Expand]WinForms Reporting
  [Collapse]WPF Reporting
   [Expand]Print
   [Expand]Document Preview
   [Collapse]End-User Report Designer
    [Expand]Quick Start
    [Collapse]GUI
     [Expand]Interface Elements
      Document Preview
     [Expand]Report Wizard
     [Collapse]Data Source Wizard
      [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
        Create a Query or Select a Stored Procedure (Obsolete)
        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
      [Expand]Connect to a JSON Data Source
      [Expand]Connect to an XPO Data Source
      [Expand]Connect to a Federated Data Source
       No Data
    [Expand]API and Customization
   [Expand]Application Security
   [Expand]Application Appearance
    Application Deployment
   [Expand]Localization
    End-User Documentation
  [Expand]Web Reporting
  [Expand]WCF Report Service
  [Expand]Discontinued Platforms
   Localization
   Redistribution and Deployment
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Create a Query or Select a Stored Procedure (Obsolete)

On this page, you can construct an SQL query to obtain data from the database or select a stored procedure.

Expanded Construct a Query

To construct an SQL query, do the following.

  1. Select the Query option and click the Run Query Builder button.

  2. In the invoked Query Builder window, select an item from the list of available tables on the left and drop it onto the list of data tables to be used.

  3. Enable the check box near the added table to include all of its fields in the data view. Click OK to exit the Query Builder. For more information, refer to the Query Builder document.

    Then, click Next to proceed to the next wizard page: Choose Fields to Display in a Report (Obsolete).

Expanded Stored Procedure

To use a stored procedure, choose the Stored Procedure option and then, select a required stored procedure from the list.

If the selected query or stored procedure contains 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 (Obsolete).

Note

This wizard page is no longer used in the default Data Source Wizard implementation. The following page is used instead: Create a Query or Select a Stored Procedure.

To learn how to switch back to using the older Report Wizard version, see the following example online: Report Designer for WPF - How to switch the Report Wizard to a single-query version.

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