Eg:- Display every branch and its report in the main report.
If you want to become a SSRS certified professional, then visit Mindmajix - A Global online training platform: “SSRS Certification Course”. This course will help you to achieve excellence in this domain.
Name Location _ SUB_Reprt
Use this report as subreport: party2
Visibility: Select SHOW
Parameters: Click ADD
Border: Style: Solid
Width : 2pt
To display the data in a more analytical way chart reports are useful.
These display data in the required chart type the chart report contains 3 sections.
a) Data Section → Have actual data presented
b) Category sections → here group-wise in-formation displayed
c) Series section → It displays the information related to the series of data presented in the report.
1) Display locations and their total incomes
Sol:- Take income on data section and location in the category section
2) Display party code wise income in a very location
Sol:- Take income on data section and location in category section & code in the series section
Chart → rt click → shape → select shape.
Taking Labels on chart:
On the chart → rt click-click show data labels
1) Chart properties
2) Chart Area properties
→ 3D options, visibility, fill, border, shadow
3) Series properties
→ Series Data:
[Sum [Party Income]]
Visibility, Axes & chart Area, Fill …..etc.Series properties
4) Legend properties
Name: Location –Code
Layout: auto table
→ Visibility, font, fill, Border, shadow ……..etc
Note:- Chart report takes parameters and it supports action implementation.
→ For changing the default dataset values go to series properties and change the value field
---- Related Page: SSRS – How To Create Dynamic Reports Using Parameters ----
This is useful to display cross tab reports. Generally, it displays data in the form of matrix-like rows against columns. It contains 3 sections.
Row Section → Row wise information displays.
Column section → It displays column-wise information
Data section → It many have summarized (or) aggregated (or) Normal data against row and column section. It also supports parameters, actions, etc..
→ Take (drag & Drop) Matrix on the layout
→ Take location in the row section, code in column section, Income in the data section
LOC*Code Party code
Party Loc [sum[prtyinc]]
→ To change color, font ..etc press F4 (or) go to generic method & change it
we can add groups in the row-wise (or) column-wise report → rt click → Insert row
The matrix report supports tablix properties.
Taking subtotal within the matrix report
a) Go to row section → rt click-click insert row → Outside group below
b) Go to column section → rt Click → click insert row → outside group right.
---- For more info: Matrix Reports in SSRS ----
It displays a list of contents
It uses tablix properties
This is used to display columnar reports (or) table reports
List box properties are rectangle properties
To change the font, color … etc go to properties (or) press F4
Take a line from the toolbox of report items and take before (or) after (or) where ever you require in the list report.
Displaying each row content in separate Go to rectangle properties à Generalà Name: Rectangle 1
Page break options à select 1st & b2nd options.
---- Related Page: Different Parts Of Creating Drill Down Reports In SSRS ----
Rectangle properties:- Change name and page break option
General → Name: [Rectangle 1]
Page break Options:
Add a page break before
Add a page break after
 Omit border o the page break
Newly added in 2008.
→ It displays information like industrial meters, bike speedometers
→ 2 types of gauges
1. Radial Guage
2. Linear Guage
Take a guage in one of the columns in the existing report
Specify a radial pointer (or) linear pointer as party code
To change the pointer values (or) work with pointers go to properties
Value: = fields! Party code. Value
Expression: =Fields! Party code.value
Pointer type: Needle
Tapered with style
Placement and size options:
Placement (relative to scale) distance
shadow → click ok
Guage panel properties:
Tooltip: MSBI Guage
Data set Name:
Page break options:
|SCCM||SQL Server DBA|
|Team Foundation Server||BizTalk Server Administrator|
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
|SSRS Training||Sep 30 to Oct 15||View Details|
|SSRS Training||Oct 03 to Oct 18||View Details|
|SSRS Training||Oct 07 to Oct 22||View Details|
|SSRS Training||Oct 10 to Oct 25||View Details|
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.
Copyright © 2013 - 2023 MindMajix Technologies