[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
  [Collapse]WinForms Reporting
   [Expand]Print API
   [Expand]Print Preview
   [Collapse]End-User Report Designer
    [Expand]Quick Start
    [Expand]GUI
    [Collapse]API and Customization
      Quick Guide to Report Designer Customization
      Add Items to the Report Designer's Standard Toolbar
      Add Items to the Report Designer's Ribbon Toolbar
      Execute Commands in the End-User Report Designer
      Override Commands in the End-User Report Designer (Implement Custom Saving)
      Hide Commands from the End-User Report Designer
      Change the Dock Panel View in the End-User Report Designer
      Customize Dock Panels in the End-User Report Designer
      Remove Dock Panels from the End-User Report Designer
      Set the Input Focus of Dock Panels in the End-User Report Designer
      Refresh the Field List in the End-User Report Designer
      Provide Custom Icons to the Field List Items
      Provide Custom Names to the Field List Items
      Hide Properties from the End-User Report Designer
      Use Favorite Properties in the End-User Report Designer
      Customize the Property Grid in the End-User Report Designer
      Register Custom Report Parameter Types
      Implement a Custom Report Gallery Storage
      Add Controls to the End-User Report Designer's Toolbox
      Make a Custom Control Available Only for a Specific Report
      Rename Toolbox Items in the End-User Report Designer
      Invoke the Report Wizard
      Wizard Customization Overview
      Report Wizard Pages
      Data Source Wizard Pages
      Customize the Report Wizard's Pages
      Remove Data Providers from the Report Wizard
      Remove Data Source Types from the Report Wizard
      Invoke and Customize the Query Builder
   [Expand]Application Security
   [Expand]Application Appearance
    Application Deployment
   [Expand]Localization
    End-User Documentation
  [Expand]WPF Reporting
  [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)

Invoke and Customize the Query Builder

This document describes how to integrate the Query Builder without using the Data Source Wizard in which it is used initially.

Expanded Invoke the Query Builder

Use the following SqlDataSourceUIHelper class methods to invoke the Query Builder in a WinForms application:

These methods' parameters include a QueryBuilderEditQueryContext instance and a custom QueryBuilderRunner implementation that define various Query Builder options.

Expanded Customize the Query Builder

This document section describes how to replace the Query Builder with a custom dialog in a Data Source Wizard:

The Create a Query or Select a Stored Procedure (Multi-Query Version) wizard page initializes and displays the standard Query Builder dialog.

Do the following to substitute the Query Builder with a custom dialog:

  1. Override the RunQueryBuilder virtual method of this page's presenter (MultiQueryConfigurePage<TModel> (see MultiQueryConfigurePage`1)).

    In this method's body, implement the logic required to display a custom Query Builder form and obtain the Query Builder execution results.

  2. Implement the IWizardCustomizationService interface to register a custom query configuration form.

    To invoke the custom query customization form instead of the default Query Builder, implement the ISqlEditorsCustomizationService interface.

  3. Add the custom services to the Report Designer by calling the XRDesignMdiController.AddService method at the application's startup.

Expanded See Also

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