Tutorial Gateway

  • C
  • C#
  • Python
  • SQL
  • Java
  • 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
  • MySQL

Create Bar Chart in SSRS Report Builder

In this article, we will show you how to create a Bar Chart in SSRS Report Builder without using Wizard. Or say steps involved in creating Bar Chart, or any Chart using SSRS Report Builder.

For this, we are going to use the Shared Data Source that we created in our Early reports and an Embedded Dataset.

To create a Bar Chart or any Chart, we have to open the report builder. To do this, Please open your report manager and click on the Report Builder button as shown in below screenshot

Create Bar Chart in SSRS Report Builder 1

Create Bar Chart in SSRS Report Builder

Once you click on the SSRS Report Builder button, SQL Server Report Builder will open with a starting page.

In this example, we want to create Bar Chart in SSRS without using Report Builder Wizard. So, Please select the New Report tab, and then select the Blank Report option

Create Bar Chart in SSRS Report Builder 2

After you select the Blank Report option, the report builder will display the Blank Report. We already explained the Designer Panes in our previous article. So please refer to Create a New Report article to understand the same.

Create Bar Chart in SSRS Report Builder 3

To create a data source, Right-click on the Data Sources folder present in the Report Data Pane. Next, select the Add Data Source option from the context menu

Create Bar Chart in SSRS Report Builder 4

By clicking on that option, it will open the Data Source Properties window to configure the Data Source.

In this example, we are selecting the Shared data Source that we created earlier. Please refer to Create Shared Data Source in Report Manager to understand the creation of Shared Data Source.

Create Bar Chart in SSRS Report Builder 5

To create a dataset for this report, Right-click on the Datasets folder present in the Report Data. Then select the Add Dataset option from the context menu.

Create Bar Chart in SSRS Report Builder 6

It will open a New window called Dataset properties. Here select the first option to select the Shared Dataset that we created earlier. Or by selecting the second option, we can create a new dataset also.

For now, we are selecting the second option. I suggest you refer the Create a New dataset in Report Builder article to understand the steps involved in creating a shared dataset.

Create Bar Chart in SSRS Report Builder 7

SQL Query that we used in our Dataset is:

-- Create Bar Chart in SSRS Report Builder
SELECT Cat.[EnglishProductCategoryName] AS ProductCategory, 
                SubCat.[EnglishProductSubcategoryName] AS ProductSubCategory, 
                Prod.EnglishProductName AS ProductName, 
                Prod.Color, 
                Fact.OrderQuantity, 
                Fact.TotalProductCost, 
                Fact.SalesAmount, 
                Fact.TaxAmt, 
                Fact.[Freight]
FROM FactInternetSales AS Fact
          INNER JOIN DimProduct AS Prod  
                 ON Fact.ProductKey = Prod.ProductKey
          INNER JOIN DimProductSubcategory AS SubCat
                 ON Prod.ProductSubcategoryKey = SubCat.ProductSubcategoryKey 
          INNER JOIN DimProductCategory AS Cat 
                  ON SubCat.ProductCategoryKey = Cat.ProductCategoryKey

Let me check the fields that the Dataset is returning.

Create Bar Chart in SSRS Report Builder 8

Within the Report Builder, please select the Insert Tab to insert the Chart in to report designer.

Create Bar Chart in SSRS Report Builder 9

Please click on the down arrow below the Charts button. Next, select the Insert Chart option from the Menu to add the table to the report region.

Create Bar Chart in SSRS Report Builder 10

Drag and drop a Chart to the Data region. As you can see from the below screenshot, by default, it is displaying the Bar Chart

Create Bar Chart in SSRS Report Builder 11

When you drag and Drop the Chart from Insert Tab to Design space, a new window called Select Chart Type will be opened to select the required chart from the available once. In this example, we are selecting a 3D Column Chart.

Create Bar Chart in SSRS Report Builder 12

Once you click the Ok button, a Three-dimensional Column chart will display in the design region with dummy data.

Create Bar Chart in SSRS Report Builder 13

Click on the empty space around the SSRS Column Chart will open the Chart Data window

Create Bar Chart in SSRS Report Builder 14

In this example, we will create a Column chart for the Sales Amount and the Total Product Cost of Products divided by Product Color. So, Drag and drop the Sales Amount and Total Product Cost column from dataset to chart data values and Color in the category group.

Let me change the report name to Bar Chart using Report Builder, and click the Run button

Create Bar Chart in SSRS Report Builder 16

Once you click the Run button, following the Bar Chart will generate.

Create Bar Chart in SSRS Report Builder 17

Let me change the Chart to regular Column Chart, and Format the Chart for a better look. I suggest you to refer Create a Column Chart, and Formatting Column Chart to understand the steps involved in changing the Chart types, and adding Data labels to charts.

Next, Please click on the Save button to save the report in the report server.

Create Bar Chart in SSRS Report Builder 18

After you click on the Save option, a new window called Save As Report will be opened. Here you have an option to select the local file system or the Report Server. Let me select the Report Server

Create Bar Chart in SSRS Report Builder 19

Let me open my Report Server to show the newly created Bar Chart Report. Here, If you want to Run the report, or to see the report preview, then you don’t have to access the Report Builder or BIDS. Just click on the Bar Chart will run the report. Let me select the report that we saved previously and click on it

Create Bar Chart in SSRS Report Builder 20

Now you can see the Bar Chart inside the Report Server

Create Bar Chart in SSRS Report Builder 21

Filed 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 | Contact | Privacy Policy