ActiveReports 14
ActiveReports 14 User Guide / Concepts / Visual Query Designer
In This Topic
    Visual Query Designer
    In This Topic
    Visual Query Designer is a graphical interface that simplifies data binding by allowing users to interactively build queries and view the results. With the Visual Query Designer's interactive interface, users who are unfamiliar with SQL can easily design, edit and preview queries.

    Visual Query Designer supports the following SQL capabilities:

    For more information on how to use these capabilites in Visual Query Designer, refer to Query Building With Visual Query Designer.

    Note: You need to have Microsoft Internet Explorer 11 or higher installed on the system to run the Visual Query Designer.

    See the graphic below to understand how a simple SQL query is generated in the Visual Query Designer.

    Limitations
    1.    
    2. Queries for XML, Object, DataSet Provider or any other specific data providers cannot be created in Visual Query Designer.
    3. Unions, nested queries and stored procedures are not supported in Design Tab.
    4. Crosses, full joins, provider-specific joins, and other SQL-specific implementation capabilities are not supported in the Design Tab.

    Accessing the Visual Query Designer

    1. Connect a Page/RDL Report to a data source. See Connect to a Data Source for details on how to connect to a data source in Page/Rdl Reports and Bind Reports to a Data Source for Section Reports.
    2. Right-click the data source node (DataSource1 by default) and select the Add Data Set option or select Data Set from the Add button on the Report Explorer toolbar to add a data set to the report.
    3. In the DataSet Dialog that appears, select the Query page and then select the edit with visual query designer button .


      This opens the Visual Query Designer in a Page Report or Rdl Report.

    In a Section Report

    1. Connect a Section Report to a data source through the Report Data Source dialog. The Query Designer button is disabled until the report connects to a data source. For more information see, Bind Reports to a Data Source.

    2. Once enabled, click the  button.

      This opens the Visual Query Designer in a Section Report.

    Elements of Visual Query Designer

     

    Database View

    Database View contains the structure of a database including namespaces, tables, views and columns. You can drag and drop or double click the elements in the Database View to add them to the Design tab. Alternatively, you can double click the crossed arrows icon on the right hand side of each element in the Database View to add it to the Design tab.

    This is the first step in query building through the Visual Query Designer. A SQL query is generated as you add the database elements to the Design tab.

    Query Tools

    The Visual Query Designer provides several tools to generate a query. The Query Tools section is divided into three major areas: Design tab, SQL tab and Toolbar buttons.

    Design Tab

    The Design tab is the area of the Visual Query Designer where you set up queries. It provides a visual interface for the SQL query you want to generate.

     

    SQL Tab


    The SQL Tab displays the SQL statement for the current query. Users can edit the query directly in the SQL Tab.

    When you switch to the SQL Tab, the Visual Query Designer automatically formats your query in the correct syntax with highlighted keywords.

    In the SQL Tab you can:

     

    Tool Bar Buttons

    Option Description
    Distinct Checkbox Distinct Checkbox is used to remove duplicates from the result set of a SELECT statement. If checked, it allows users to display only distinct values.
    Execute Allows users to execute their query and display the result in Results panel.
    Save Allows users to save the query to a DataSet dialog.
    Clear Allows users to clear all the panels in the Visual Query Designer and the SQL tab along with it.

     

    The Query Tools section also has a dropdown on the top right corner with two options:

    1. Toggle Panels: To expand or collapse the Selected Fields and the Tables and Relationships panel.
    2. Show Hints: To show or hide hints on how to use the Visual Query Designer effectively.
      Example: "Double click the table or field name in the database view or drag and drop it here." appears at the top of the Selected Fields panel.

    Result panel

    Displays the result of the query set in the Visual Query Designer.

    This panel is populated when you click the Execute button on the Visual Query Designer toolbar after adding the required fields or tables in the Selected Fields panel.

    See Also