We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Create data model with query builder

The ASP.NET Report Designer provides a graphical or text-based query builder for each data provider. It helps you to specify which data to retrieve from a data source. Query builder lets you to interactively build a query to a data set in less time.

SQL query builder

The SQL query builder comes with a convenient user interface that helps both technical and nontechnical users to create and view relationships between tables with a few clicks. It contains both graphical and text-based mode to create SQL queries easily.

ASP.NET Report Designer SQL query builder

ASP.NET Report Designer Graphical query designer

Graphical query designer

You can explore the database tables in hierarchical view and interactively build the queries for a data set. A simple drag-and-drop of tables to the query design view will generate the queries for your dataset.

Text-based query designer

The text-based query designer lets you write queries in the query syntax that is supported by the data source. You can preview the query result by executing the query. This is the default mode available for built-in data sources except SQL.

ASP.NET Report Designer Text-based query designer

ASP.NET Report Designer Table relationship

Table relationship

You can use one or more related tables to create queries. Query builder provides a dialog interface to manage relationship between sets of two tables. You can specify the column names to join two tables.

Query filter

Provides a user interface to add filters to a dataset to limit data. The filter criteria mentioned in a data set is automatically added to the query during execution.

ASP.NET Report Designer Query filter

Query parameter support in ASP.NET Report Designer

Query parameter

Provides a user interface to add or manage query parameters to a data set. The query parameter takes values at run-time to filter the data. You can also add user defined parameters for internal data set query related calculations.

Customize query designer

The ASP.NET Report Designer supports extending the functionalities of the query designer. It allows users to enable graphical database view for required data source type that does not have native support.

Customize query designer support in ASP.NET Report Designer


Scroll up icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon