Mindmajix

Different Types of Reports in SSRS with Example

Taking Sub Reports

Sub Report displays the content in the main report or It is the report in the main report.
It can take parameters

Generally sub reports 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

Main Report

Screenshot_129

Screenshot_130

  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 tool box to the column and specify the below sub report properties:

General:

Name: Location _ SUB_Reprt

Use this report as sub report : 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 more analytical way chart reports are useful

These display data  in 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 series of data presented in the report.

Types of Charts:

Screenshot_131

  • Column
  • LINE
  • SHAPE
  • BAR
  • AREA
  • RANGE
  • SCATTER
  • POLAR

1) Display locations and their total incomes.
Sol:- Take income on data section and location in the category section
Screenshot_132

2) Display party code wise income in very location
Sol:- Take income on data section and location in category section & code in series section

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

Matrix Report

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

LOC*Code Party code
Party Loc [sum[prtyinc]]

→ To change color, font ..etc press F4 (or) go to generic method & change it

STATES*STATISTICS SALES Marketing HR
10 20 30 40 50 100
AP 8000 7000 6000 50000 70000 60000
  VSKP
RR 4000 30000 40000 40000 60000 70000
Medak 7000 20000 10000 30000 50000 80000
UP 6000 70000 60000 50000 70000 50000
Alahabad
———- 4000 60000 80000 70000 60000 70000
—-            
MP            
           

State                                                 → Row Group
District                                            →  Sub Group of main row
Sales                                                → Column Group
Department                                    → Column sub Group
Sum of rupees                                →  Data section.

  • we can add groups in the row wise (or) column wise report → rt click → Insert row
  • Matrix report supports tablix properties.
  • Taking subtotal with in the matrix report

a) Go to row section → rt click → click insert row → Out side group below
b) Go to column section → rt Click → click insert row → out side group right.

List Report

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

Screenshot_133

To change the font, color … etc go to properties (or) press F4

  • Take line from tool box 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.

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 guages

  1. Radial Guage
  2. Linear Guage

  • Take a guage in one of the column 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! Partycode.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:

Tool tip: MSBI Guage

Data set Name:

DB_MSBI

Page break options:

b) Visibility

c) Filter

d) Fill

e)Borders

Screenshot_134

Scale Properties

Screenshot_135

Enroll for Live Instructor Led Online MSBI Training


0 Responses on Different Types of Reports in SSRS with Example"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.