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

Add Rectangle to SSRS Report

by suresh

In this article, we will show you how to add Rectangle to SSRS Report. It is one of the most useful Report Item while you are designing a report because you can use this Rectangle to combine Images, Text Boxes, Charts in one place.

So, here we will show you the step by step approach to add Rectangle to SSRS Report with an example.

To explain the same, We are going to use the below-shown DataSet. Please refer to Embedded Data Source and Dataset articles to understand the steps involved in creating Embedded Data Source and Dataset that we used for this SSRS report.

Add Rectangle to SSRS Report 1

and the Custom SQL query that we used in the above Dataset is:

-- Displaying Rectangle on SSRS Report
USE [AdventureWorksDW2014]
GO
SELECT [FirstName] + ' ' + [LastName] AS [FullName]
      ,[EmailAddress]
      ,[Gender]
      ,[Title]
      ,SUM(FACT.SalesAmount) AS SalesAmount
      ,SUM(FACT.TotalProductCost) AS ProductCost
      ,[EmployeePhoto]
  FROM [DimEmployee] AS EMP
  INNER JOIN [FactResellerSales] AS FACT ON
  EMP.EmployeeKey = FACT.EmployeeKey
  GROUP BY [FirstName]
      ,[LastName]
      ,[EmailAddress]
      ,[Gender]
      ,[Title]
      ,[EmployeePhoto]

Data written by the above query is:

Add Rectangle to SSRS Report 0

Add Rectangle to SSRS Report

To demonstrate the steps involved to add Rectangle to SSRS Report, We are going to use the previously generated report that we shown below. Please refer to Create a New Report, and Add headers and Footer to SSRS Report article for adding Page headers and footers.

Add Rectangle to SSRS Report 2

For the demonstration purpose, we will add a Rectangle inside the SSRS report area. And to do so, right-click on the report area, and select the Insert, and then Rectangle option.

Add Rectangle to SSRS Report 3

Once you select the Rectangle option from the context menu, a new Rectangle will add to the report area.

Add Rectangle to SSRS Report 1Add Rectangle to SSRS Report 4

You can use your mouse to increase or decrease the width and height of a Rectangle.

Add Rectangle to SSRS Report 5

For the demo purpose, we will add a Textbox inside the Rectangle area. To do so, right-click on the Rectangle, and select the Insert, and then Text Box option.

Add Rectangle to SSRS Report 6

Let me add some text to the text box, and then we are adding the Image to the Rectangle. I suggest you refer to Display Image in SSRS Report article to understand the steps involved in adding an image to report.

Add Rectangle to SSRS Report 7

Within the SSRS Report preview, you can see the Text that we entered in the textBox and the Image

Add Rectangle to SSRS Report 8

Rectangle Properties: Right-click on the rectangle will open the context menu. Please select the Rectangle Properties.. option from it to alter the existing properties of a rectangle.

Add Rectangle to SSRS Report 9

Once you select the Rectangle Properties.. option, a new window called rectangle Properties will open. Under the general tab, you can change the name of the rectangle, or you can add the page breaks too.

Add Rectangle to SSRS Report 10

Visibility: Use this tab to decide whether you want to show the rectangle to the user, or not.

Add Rectangle to SSRS Report 11

Under the Fill tab, we can change the background color of a rectangle. Let me change the Background color to Turquoise

Add Rectangle to SSRS Report 12

We have an option to use the External Image as the background of a rectangle.

We already explained the steps involved in adding an image to Report, or rectangle in Display Image in SSRS Report article, so please refer to it.

Add Rectangle to SSRS Report 13

You can use the Border tab to change the Border style, Color, Type, width, and pattern. For the demo purpose, we changed the Presents from None to Outline, Style to Solid, Width to 2pt, and Color to Brown

Add Rectangle to SSRS Report 14

Click the OK button to close the properties window. Please adjust the Report Items (align) so that there will display in one line

Add Rectangle to SSRS Report 15

As you can see, our Rectangle is filed with the Turquoise color and surrounded by the Borders color that we specified.

Add Rectangle to SSRS Report 16

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