SSRS: Graphic Query Designer

Using the graphic query designer to quickly construct sql to populate the dataset.

The Graphic Query Designer provides one of the most efficient methods for creating sql necessary to populate a report’s dataset and avoids and syntax errors by writing the sql for the user.

I’ll begin this example by creating a new dataset for my Sales History report.

1-graphic-query-designer

When the Data window is first loaded, it defaults to the Generic Query designer.

2-graphic-query-designer

By deselecting that button, the Graphic Query Designer loads with the Diagram, Grid, SQL, and Results panes to easily construct sql for populating a dataset.

3-graphic-query-designer

To show sales history, I’ll use the “Add Table” button (or right-click -> Add Table) to add the Employees, Orders, and Customers tables – notice the relationships are automatically discovered.

4-graphic-query-designer

With the tables added, I’ll select those fields I wish to display in the report.

5-graphic-query-designer

Using the Grid Pane, I’ll update the sort order accordingly.

6-graphic-query-designer

By hiding all the panes except the Results pane, I can now execute the sql and view the results of my query.

7-graphic-query-designer

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s