[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)

Configure Query Parameters

On this wizard page, you can manage parameters that are used in queries and/or stored procedures selected on the previous wizard page, as well as specify parameter values.

Expanded Specify Parameter Values

You can specify a parameter value in one of the following ways:

  • To provide a static value for a query parameter, choose the parameter type, and then, specify its actual value in the Value column according to the selected type.

  • You can link a query or stored procedure parameter to a report parameter, whose value can be requested each time before previewing or exporting the report document. To do this, enable the Expression check box and select an existing report parameter of the corresponding type or create a new one.

  • Another option is to calculate a parameter value based on an expression. To do this, enable the Expression check box and run the Expression Editor by clicking the ellipsis button.

Expanded Manage Parameters

To delete a specific parameter, select it on this wizard page and click Remove.

To execute a specific query with the specified parameter values, click Preview and select a query.

To create a new query parameter, click Add and select a query.

You can stop the wizard at this step by clicking Finish.

To continue report customization, click Next to proceed to the next wizard page: Choose Fields to Display in a Report.

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