Home / SSRS

Types of Reports in SSRS

Rating: 5.0Blog-star
Views: 11085
by Ravindra Savaram
Last modified: February 1st 2021

Types of SSRS Reports

Taking Sub Reports

  • Sub Report displays the content in the main report or is the report in the main report.
  • It can take parameters.
  • Generally, subreports are taken in real-time to display particular information for every row (or) set of rows in the main report

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.

Main Report

  1. Create a report (report2) and take a parameter to the report
  2. Take a new column in the main Report and Drag and Drop sub-report from the toolbox to the column and specify the below subreport properties:

General:

Name Location _ SUB_Reprt

Use this report as subreport: party2

Visibility: Select SHOW

Parameters: Click ADD

Name                    Value

VARLOC               [PARTYLOC]

Border: Style: Solid

Width                    : 2pt

Working with Chart Report

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.

Types of Charts:

 

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

Frequently Asked SSRS Interview Questions & Answers

Changing Chart Type:

Chart → rt click → shape → select shape.

Taking Labels on chart:

On the chart → rt click-click show data labels

1) Chart properties

  • General
  • Visibility
  • Filter
  • Fill
  • Border

2) Chart Area properties

→ 3D options, visibility, fill, border, shadow

3) Series properties

→ Series Data:

Value field:

[Sum [Party Income]]

  • Visibility, Axes & chart Area, Fill …..etc.Series properties

4) Legend properties

  • General:

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    ----

Matrix Reports:

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

 
Matrix Report
 
  • 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     ----

List Report:

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

  • Drag and drop text boxes and design like below
 

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

  • Visibility

  • Fill

  • Border

Guage Report

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

Pointer Options:

Value:                                                   = fields! Party code. Value

Expression:                                         =Fields! Party code.value

Pointer type:                                     Needle

Needle

Marker

Bar

Needle style:

Tapered

Tapered with style

Placement and size options:

Placement (relative to scale) distance

Inside                                                    0

Width

15

  • Action

  • pointer fill

  • pointer border.

  • cap options

  • cap fill

  • shadow → click ok

Guage panel properties:

a) General

Name:

Tooltip: MSBI Guage

Data set Name:

DB_MSBI

Page break options:

b) Visibility

c) Filter

d) Fill

e)Borders

Guage panel properties

Scale Properties:

Scale Properties
 

List of Related Microsoft Certification Courses:

 SSIS  Power BI
 SSAS  SQL Server
 SCCM  SQL Server DBA
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator

 

About Author

author
NameRavindra Savaram
Author Bio

 

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.