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

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

Deep Dive SSRS Reporting from the Scratch Report from the scratch

By: Vikas Munjal

4 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

€67.28

List Price: €96.12

You save: €28.84

£55.93

List Price: £79.91

You save: £23.97

CA$98.01

List Price: CA$140.02

You save: CA$42.01

A$107.87

List Price: A$154.11

You save: A$46.23

S$94.42

List Price: S$134.90

You save: S$40.47

HK$544.78

List Price: HK$778.29

You save: HK$233.51

CHF 62.22

List Price: CHF 88.89

You save: CHF 26.67

NOK kr779.46

List Price: NOK kr1,113.56

You save: NOK kr334.10

DKK kr501.79

List Price: DKK kr716.88

You save: DKK kr215.08

NZ$119.98

List Price: NZ$171.41

You save: NZ$51.43

د.إ257.07

List Price: د.إ367.26

You save: د.إ110.18

৳8,402.58

List Price: ৳12,004.20

You save: ৳3,601.62

₹5,911.93

List Price: ₹8,445.97

You save: ₹2,534.04

RM312.68

List Price: RM446.70

You save: RM134.02

₦118,358.68

List Price: ₦169,091.08

You save: ₦50,732.40

₨19,451.98

List Price: ₨27,789.74

You save: ₨8,337.75

฿2,421.30

List Price: ฿3,459.15

You save: ฿1,037.85

₺2,419.75

List Price: ₺3,456.94

You save: ₺1,037.18

B$406.81

List Price: B$581.19

You save: B$174.37

R1,266.21

List Price: R1,808.95

You save: R542.74

Лв131.43

List Price: Лв187.77

You save: Лв56.33

₩98,455.31

List Price: ₩140,656.47

You save: ₩42,201.16

₪260.61

List Price: ₪372.31

You save: ₪111.70

₱4,125.84

List Price: ₱5,894.31

You save: ₱1,768.47

¥10,813.84

List Price: ¥15,449

You save: ¥4,635.16

MX$1,432.62

List Price: MX$2,046.69

You save: MX$614.07

QR256.35

List Price: QR366.23

You save: QR109.88

P959.91

List Price: P1,371.36

You save: P411.45

KSh9,063.70

List Price: KSh12,948.70

You save: KSh3,885

E£3,476.67

List Price: E£4,966.88

You save: E£1,490.21

ብር8,762.26

List Price: ብር12,518.05

You save: ብር3,755.79

Kz63,877.12

List Price: Kz91,256.94

You save: Kz27,379.82

CLP$68,152.06

List Price: CLP$97,364.26

You save: CLP$29,212.20

CN¥507.37

List Price: CN¥724.85

You save: CN¥217.47

RD$4,236.71

List Price: RD$6,052.70

You save: RD$1,815.99

DA9,355.50

List Price: DA13,365.57

You save: DA4,010.07

FJ$159.32

List Price: FJ$227.62

You save: FJ$68.29

Q542.77

List Price: Q775.43

You save: Q232.65

GY$14,710.67

List Price: GY$21,016.15

You save: GY$6,305.47

ISK kr9,775.50

List Price: ISK kr13,965.60

You save: ISK kr4,190.10

DH703.21

List Price: DH1,004.63

You save: DH301.41

L1,276.61

List Price: L1,823.81

You save: L547.19

ден4,112.73

List Price: ден5,875.58

You save: ден1,762.85

MOP$563.70

List Price: MOP$805.33

You save: MOP$241.62

N$1,272.29

List Price: N$1,817.64

You save: N$545.34

C$2,573.53

List Price: C$3,676.63

You save: C$1,103.10

रु9,461.06

List Price: रु13,516.38

You save: रु4,055.32

S/267.08

List Price: S/381.56

You save: S/114.48

K283.05

List Price: K404.37

You save: K121.32

SAR262.80

List Price: SAR375.44

You save: SAR112.64

ZK1,938.90

List Price: ZK2,769.98

You save: ZK831.07

L334.76

List Price: L478.25

You save: L143.49

Kč1,707.89

List Price: Kč2,439.96

You save: Kč732.06

Ft27,663.65

List Price: Ft39,521.19

You save: Ft11,857.54

SEK kr779.03

List Price: SEK kr1,112.95

You save: SEK kr333.92

ARS$70,272.32

List Price: ARS$100,393.34

You save: ARS$30,121.01

Bs485.83

List Price: Bs694.07

You save: Bs208.24

COP$310,661.31

List Price: COP$443,820.90

You save: COP$133,159.58

₡35,743.76

List Price: ₡51,064.70

You save: ₡15,320.94

L1,776.85

List Price: L2,538.46

You save: L761.61

₲551,865.53

List Price: ₲788,413.13

You save: ₲236,547.59

$U2,996.30

List Price: $U4,280.61

You save: $U1,284.31

zł292.33

List Price: zł417.63

You save: zł125.30

Already have an account? Log In

Deep Dive SSRS Reporting from the Scratch

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

Sign Up

Sign Up

Share