Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

SSRS Query Designer

by suresh

The SSRS Query Designer makes the developer’s life easy to design the SQL Queries. If you don’t know how to write the SQL Queries or if you find it challenging to perform Grouping, Sorting, and Join operations.

Or, if you find it challenging to design the complex SQL Queries, use SSRS Query Designer to create your desired queries using a Graphical User Interface.

SSRS Query Designer Example

In this example, we will show you how to design an SQL Query using SSRS Query Designer. For this example, we will design the query against the Adventure Works DW database.

First, Right-click on the Shared Dataset and click on Add New Dataset option. Next, select the Query type as Text and click on the SSRS Query Designer button, as shown below.

SSRS Query Designer 1

Once you click on the Query Designer button, it will open the Query Designer in a separate window. Before designing the SQL query, you should understand the different panes present in the SSRS Query Designer.

  • Diagram Pane: This pane is used to select the tables, views, or functions. SSRS Query Designer will automatically join the tables as per the database relations. After selecting the required tables, we can choose the columns needed by check-marking the columns.
  • Grid Pane: All the selected columns will display in this panes. This pane is handy to apply sorting (ORDER BY ASC and ORDER BY DESC) and also grouping the column names (GROUP BY Statement)
  • SQL Pane: SSRS Query Designer will automatically build the SQL query for us in this pane.
  • Result Pane: Once you finished designing your SQL query, then click on the Execute button will display the SQL Query result in this pane.
SSRS Query Designer 2

Right Click on the Diagram Pane will open the context menu. Click on the Add table.. option and add the required table.

SSRS Query Designer 3

From the below screenshot, you can observe that we selected the Customers table and Fact Internet Sales table. Please choose the required columns by check-marking the column names in the Diagram Pane.

SSRS Query Designer 4

From the above screenshot, you can observe that SSRS Query Designer automatically applied the Inner Join between the two tables Customers and Fact Internet Sales using the CustomerKey column.

Sorting: Within the Grid Pane, Please change the Sort Type to Ascending or Descending as per your requirement. In this SSRS query designer example, we are sorting First Name Ascending and the Last Name Descending

SSRS Query Designer 5

Please change the Sort Order option as per your requirement. For this example, it will sort the data by First Name in the Ascending order first, and then it will sort the Data by the Last Name in descending order.

From the above screenshot, you can see the final SQL Query generated by the SSRS Query Designer. Let us see whether the built query is executing perfectly or not by clicking the execute button on the top.

SSRS Query Designer 6

The built query is executing flawlessly. If you like to see the generated code behind this query, select Edit as Text option on top of a designer.

SSRS Query Designer 7

Now, you can see the result. Click ok button to finish designing the SQL Query using the Query Builder tool in SSRS

SSRS Query Designer 8

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021 · All Rights Reserved by Suresh

About Us | Contact Us | Privacy Policy