Customize the Query

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

Construct a Query

To construct an SQL query, do the following.

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

    WpfDesignerReportWizard_RunQueryBuilder

  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.

    WPDDesigner_QueryBuilder_AddingTable

  3. Enable the check box near the added table to include all of its fields in the data view.

    wpf-designer-query-builder-select-products-fields

    Click OK to exit the Query Builder.

    For more information on the Query Builder, refer to the Query Builder document.

Select a Stored Procedure

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

WpfDesigner_ReportWizard_SelectingStoredProcedure

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 Columns to Display in a Report.