Deep Dive SSRS Reporting from the Scratch

Introduction

Installation required for this course

Preview

Life cycle of reporting process

Shared and embedded datasource and dataset

How to restore database using SSMS for performing practicals

Please download database for practice

Report generation using report wizard

Report from the scratch

SSDT components explained

Dataset used in SSRS reporting explained

Please download the Dataset used in the report creation

First tablix report

SSRS grouping

Why to create Black and White report

DrillDown option

Page break in SSRS

Merge and sort a column based on another column

Add calculated field

How to display loss in red color

How to create Profit% column using the keyword report items in an expression

Advantage of creating calculated field

Report header , Report footer , Page header and Page footer

How to reset page number on the basis of a group

How to create document map

How to display first 3 characters of every month for the consistent report

How to repeat column header on each page of a report in SSRS

How to freeze the headers of a table in the SSRS report

How to hide the advanced mode

How to display different currency symbols in SSRS

Parameterized reports

How to add parameters in the report

How to use dropdown parameters in SSRS report

How to implement multi-select parameters option for SSRS reports

How to add All option to SSRS dropdown

Fixing the No record issue in the report

How to manually add the options in SSRS dropdown

How to setup the default value in the dropdown

How to generate Cascading Parameters in the SSRS report

How to deal with Multiple Values in the Cascading parameters

Display no data available for empty dataset and dynamically play with parameters

How to use a column which has Date Datatype as a Parameter

Chart reports

Creating charts

How to make Lower values visible in SSRS charts using Scale breaks option

Tooltip data labels and changing chart types

Mixture of columns and lines in a single chart

Dynamically changing the chart title based on the Dropdownlist selected options

Displaying a tabular report after clicking on a chart using Drillthrough option

Changing vertical axis values (in Millions or Billions) in the chart

Major ticks, Minor ticks, Major gridlines & Minor gridlines

Pie chart

Legends in the Pie chart

Advanced reporting

Matrix report

Please download Dataset used in the following report

How to convert detailed data into summary

Please download the dataset used in the following report creation

List in SSRS

Table inside a list

How to name worksheets with the group name values when exporting report to excel

Please download the dataset used in the following report creation

Sum function with different scopes in an expression

Indicators in SSRS

Please download the Dataset used in the following Report creation

Databars and creating trends using sparklines

Gauge in SSRS

Please download Dataset used in the following report

Using stored procedures as Dataset

Subreport in SSRS

Sum function with different scopes in an expression

Deep Dive SSRS Reporting from the Scratch Advanced reporting

By: Vikas Munjal

11 minutes

Share the link to this page

Copied

Facebook

Twitter

Add the class to your calendar

Add to Google Calendar

Add to Apple Calendar

Add to Yahoo Calendar

Add to Outlook Calendar

Completed

You need to have access to the item to view this lesson.

One-time Fee

$69.99

List Price: $99.99

You save: $30

€59.22

List Price: €84.61

You save: €25.38

£51.40

List Price: £73.43

You save: £22.03

CA$95.78

List Price: CA$136.84

You save: CA$41.05

A$99.78

List Price: A$142.55

You save: A$42.77

S$89.09

List Price: S$127.27

You save: S$38.18

HK$546.89

List Price: HK$781.30

You save: HK$234.41

CHF 54.28

List Price: CHF 77.55

You save: CHF 23.26

NOK kr678.24

List Price: NOK kr968.96

You save: NOK kr290.71

DKK kr442.49

List Price: DKK kr632.15

You save: DKK kr189.66

NZ$116.35

List Price: NZ$166.23

You save: NZ$49.87

د.إ257.03

List Price: د.إ367.21

You save: د.إ110.17

৳8,534.69

List Price: ৳12,192.95

You save: ৳3,658.25

₹6,340.84

List Price: ₹9,058.74

You save: ₹2,717.89

RM276.21

List Price: RM394.61

You save: RM118.39

₦95,450.80

List Price: ₦136,364.14

You save: ₦40,913.33

₨19,514.05

List Price: ₨27,878.42

You save: ₨8,364.36

฿2,201.06

List Price: ฿3,144.51

You save: ฿943.44

₺3,052.43

List Price: ₺4,360.81

You save: ₺1,308.37

B$365.14

List Price: B$521.65

You save: B$156.51

R1,122.95

List Price: R1,604.29

You save: R481.33

Лв115.84

List Price: Лв165.49

You save: Лв49.65

₩102,451.36

List Price: ₩146,365.36

You save: ₩43,914

₪217.71

List Price: ₪311.04

You save: ₪93.32

₱4,095.29

List Price: ₱5,850.66

You save: ₱1,755.37

¥11,002.46

List Price: ¥15,718.47

You save: ¥4,716.01

MX$1,208.27

List Price: MX$1,726.18

You save: MX$517.90

QR254.85

List Price: QR364.09

You save: QR109.24

P923.90

List Price: P1,319.92

You save: P396.01

KSh9,002.30

List Price: KSh12,860.99

You save: KSh3,858.68

E£3,279.73

List Price: E£4,685.53

You save: E£1,405.80

ብር10,848.96

List Price: ብር15,499.18

You save: ብር4,650.22

Kz63,840.19

List Price: Kz91,204.18

You save: Kz27,363.99

CLP$60,253.69

List Price: CLP$86,080.39

You save: CLP$25,826.70

CN¥485.65

List Price: CN¥693.82

You save: CN¥208.16

RD$4,404.37

List Price: RD$6,292.23

You save: RD$1,887.86

DA9,072.37

List Price: DA12,961.08

You save: DA3,888.71

FJ$154.64

List Price: FJ$220.92

You save: FJ$66.28

Q535.26

List Price: Q764.69

You save: Q229.43

GY$14,600.55

List Price: GY$20,858.83

You save: GY$6,258.27

ISK kr8,588.47

List Price: ISK kr12,269.77

You save: ISK kr3,681.30

DH640.66

List Price: DH915.27

You save: DH274.60

L1,189.85

List Price: L1,699.85

You save: L510

ден3,648.21

List Price: ден5,211.96

You save: ден1,563.74

MOP$561.59

List Price: MOP$802.31

You save: MOP$240.71

N$1,125.86

List Price: N$1,608.44

You save: N$482.58

C$2,568.28

List Price: C$3,669.13

You save: C$1,100.84

रु10,114.02

List Price: रु14,449.23

You save: रु4,335.20

S/234.80

List Price: S/335.45

You save: S/100.64

K299.26

List Price: K427.54

You save: K128.27

SAR262.44

List Price: SAR374.93

You save: SAR112.49

ZK1,299.76

List Price: ZK1,856.89

You save: ZK557.12

L301.68

List Price: L430.99

You save: L129.31

Kč1,435.08

List Price: Kč2,050.20

You save: Kč615.12

Ft22,375.80

List Price: Ft31,966.80

You save: Ft9,591

SEK kr631.53

List Price: SEK kr902.22

You save: SEK kr270.69

ARS$100,651.37

List Price: ARS$143,793.83

You save: ARS$43,142.46

Bs482.22

List Price: Bs688.92

You save: Bs206.69

COP$258,930.03

List Price: COP$369,915.90

You save: COP$110,985.86

₡34,596.92

List Price: ₡49,426.29

You save: ₡14,829.37

L1,851.58

List Price: L2,645.23

You save: L793.65

₲461,092.35

List Price: ₲658,731.59

You save: ₲197,639.24

$U2,684.12

List Price: $U3,834.62

You save: $U1,150.50

zł249.84

List Price: zł356.94

You save: zł107.09

Already have an account? Log In

Deep Dive SSRS Reporting from the Scratch

Sum function with different scopes in an expression

Sign Up

Sign Up

Share