%PDF-1.6
%
1 0 obj
<>
endobj
2 0 obj
<>stream
2021-02-25T06:13:35-05:00
2021-02-25T06:13:35-05:00
2021-02-25T06:13:35-05:00
Adobe Acrobat 21.0
application/pdf
SQL Server 2017 Reporting Services Course | SSRS 2017 Training
uuid:dd1575e4-cba8-4e46-9f38-29bf025ae84f
uuid:d6189686-07b3-4f1c-842e-32c9708e508a
Acrobat Web Capture 15.0
endstream
endobj
5 0 obj
<>
endobj
6 0 obj
<>
endobj
3 0 obj
<>
endobj
7 0 obj
<>
endobj
8 0 obj
<>
endobj
15 0 obj
<>>>
endobj
16 0 obj
<>
endobj
17 0 obj
<>
endobj
19 0 obj
[18 0 R 18 0 R]
endobj
20 0 obj
[18 0 R 18 0 R]
endobj
21 0 obj
[18 0 R 18 0 R]
endobj
18 0 obj
<><><><>]/P 16 0 R/Pg 12 0 R/S/Article>>
endobj
12 0 obj
<>/Font<>/ProcSet[/PDF/Text/ImageC]/XObject<>>>/StructParents 0/Type/Page>>
endobj
22 0 obj
[34 0 R 35 0 R 36 0 R 37 0 R]
endobj
23 0 obj
<>stream
BT
/Artifact <>BDC
/TT0 1 Tf
9 0 0 9 5 779 Tm
(SQL Server 2017 Reporting Services Course | SSRS 2017 Training)Tj
EMC
/Artifact <>BDC
0 -86 TD
(file:///INSTSERVER/TrainingHottSite/HOTT-NEW/Canada/CoursesPDF/SQL-Serve\
r-2017-Reporting-Services-Training.htm)Tj
50.797 0 Td
([2/25/2021 6:13:35 AM])Tj
EMC
ET
1 g
10 36 591.75 729.75 re
f
q
65.5 513 m
63.429 513 61.75 511.321 61.75 509.25 c
61.75 509.25 l
61.75 242.25 l
61.75 240.179 63.429 238.5 65.5 238.5 c
65.5 238.5 l
545.5 238.5 l
547.571 238.5 549.25 240.179 549.25 242.25 c
549.25 242.25 l
549.25 509.25 l
549.25 511.321 547.571 513 545.5 513 c
545.5 513 l
h
W n
0.976 g
61.75 513 487.5 -274.5 re
f
0.867 g
61.75 513 487.5 -274.5 re
65.5 512.25 m
545.5 512.25 l
547.157 512.25 548.5 510.907 548.5 509.25 c
548.5 242.25 l
548.5 240.593 547.157 239.25 545.5 239.25 c
65.5 239.25 l
63.843 239.25 62.5 240.593 62.5 242.25 c
62.5 509.25 l
62.5 510.907 63.843 512.25 65.5 512.25 c
f*
Q
q
10 36 592 730 re
W n
0.137 0.322 0.486 rg
q 1 0 0 1 69.25 508.5 cm
0 0 m
472.5 0 l
474.157 0 475.5 -1.343 475.5 -3 c
475.5 -17.25 l
475.5 -18.907 474.157 -20.25 472.5 -20.25 c
0 -20.25 l
-1.657 -20.25 -3 -18.907 -3 -17.25 c
-3 -3 l
-3 -1.343 -1.657 0 0 0 c
f
Q
q 1 0 0 1 64.75 225 cm
0 0 m
481.5 0 l
483.157 0 484.5 -1.343 484.5 -3 c
484.5 -20.25 l
484.5 -21.907 483.157 -23.25 481.5 -23.25 c
0 -23.25 l
-1.657 -23.25 -3 -21.907 -3 -20.25 c
-3 -3 l
-3 -1.343 -1.657 0 0 0 c
f
Q
/Article <>BDC
EMC
/Article <>BDC
Q
q
61.75 677.25 487.5 82.5 re
W n
q
/GS0 gs
487.5 0 0 -82.5 61.75 759.75 cm
/Im0 Do
Q
Q
BT
0.608 0.169 0 rg
/TT1 1 Tf
19.5 0 0 19.5 61.75 636.75 Tm
(SQL Server 2017 Reporting Services)Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
10.5 0 0 10.5 61.75 609 Tm
(Duration:)Tj
0 g
/TT3 1 Tf
( 3 Days )Tj
/TT4 1 Tf
9.48 0 Td
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
15.164 0 Td
(, or 21 Hours )Tj
/TT4 1 Tf
7.014 0 Td
(\(On-Demand\))Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-31.658 -2.214 Td
(Price:)Tj
0 g
/TT3 1 Tf
3.227 0 Td
( CDN$2,275 )Tj
/TT4 1 Tf
6.462 0 Td
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
15.164 0 Td
(, or CDN$1,995 )Tj
/TT4 1 Tf
8.211 0 Td
(\(On-Demand\))Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-33.064 -2.214 Td
(Discounts:)Tj
0 g
/TT3 1 Tf
5.916 0 Td
( We offer multiple discount options. )Tj
0.137 0.322 0.486 rg
18.297 0 Td
(Click here)Tj
ET
q
10 36 592 730 re
W n
0.137 0.322 0.486 RG
0.75 w
q 1 0 0 1 315.9854 561.75 cm
0 0 m
52.105 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 368.0906 562.5 Tm
( for more info.)Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
0.429 Tw -29.175 -2.214 Td
[(Delivery )1 (Options:)]TJ
0 g
/TT3 1 Tf
0.441 Tw [( )0.9 (Atten)0.8 (d )0.9 (face-to-face )3.1 (in )0.8 (the )1.3 (classroom, )]TJ
0.137 0.322 0.486 rg
0 Tw 32.218 0 Td
(remote-live)Tj
ET
q
10 36 592 730 re
W n
0.137 0.322 0.486 RG
0.75 w
q 1 0 0 1 400.0432 538.5 cm
0 0 m
60.713 0 l
h
S
Q
Q
BT
0 g
0.464 Tw 10.5 0 0 10.5 460.7566 539.25 Tm
( or )Tj
0.137 0.322 0.486 rg
0 Tw 2.665 0 Td
(on-demand)Tj
ET
q
10 36 592 730 re
W n
0.137 0.322 0.486 RG
0.75 w
q 1 0 0 1 488.7432 538.5 cm
0 0 m
60.288 0 l
h
S
Q
Q
BT
10.5 0 0 10.5 61.75 526.5 Tm
(training)Tj
ET
q
10 36 592 730 re
W n
0.137 0.322 0.486 RG
0.75 w
q 1 0 0 1 61.75 525.75 cm
0 0 m
40.518 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 102.2683 526.5 Tm
(.)Tj
1 g
/T1_0 1 Tf
14.25 0 0 14.25 69.25 494.25 Tm
(Students Will Learn)Tj
ET
q
81.25 243 231.75 234 re
W n
0 g
81.25 471.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 471.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
BT
/TT3 1 Tf
10.5 0 0 10.5 91 467.25 Tm
(Installing and configuring SQL Server)Tj
-0.929 -1.214 Td
(Reporting Services)Tj
ET
81.25 438.75 3 -3 re
f
q 1 0 0 1 81.25 438.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
0 g
/TT3 1 Tf
10.5 0 0 10.5 91 434.25 Tm
(Designing reports using SQL Server)Tj
ET
q
81.25 243 231.75 234 re
W n
BT
10.5 0 0 10.5 81.25 421.5 Tm
(Data )Tj
ET
Q
BT
10.5 0 0 10.5 109.7815 421.5 Tm
(Tools \(SSDT\))Tj
ET
q
81.25 243 231.75 234 re
W n
81.25 405.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 405.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 401.25 Tm
(Creating multi-dimensional, two-)Tj
ET
q
81.25 243 231.75 234 re
W n
BT
10.5 0 0 10.5 81.25 388.5 Tm
(dimensional and tabular data sources)Tj
0 -1.214 TD
(and sets)Tj
ET
81.25 360 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 360 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 355.5 Tm
(Using the Tablix object to display)Tj
ET
q
81.25 243 231.75 234 re
W n
BT
10.5 0 0 10.5 81.25 342.75 Tm
(information )Tj
ET
Q
BT
10.5 0 0 10.5 145.5676 342.75 Tm
(in Tables, Matrix \(pivot)Tj
ET
q
81.25 243 231.75 234 re
W n
BT
10.5 0 0 10.5 81.25 330 Tm
(tables\) )Tj
ET
Q
BT
10.5 0 0 10.5 121.3018 330 Tm
(and free form Lists)Tj
ET
q
81.25 243 231.75 234 re
W n
81.25 314.25 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 314.25 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 309.75 Tm
(Using visualization objects to create)Tj
ET
q
81.25 243 231.75 234 re
W n
BT
10.5 0 0 10.5 81.25 297 Tm
(Charts, Spark Lines, Data Bars )Tj
ET
Q
BT
10.5 0 0 10.5 247.8298 297 Tm
(and Tree)Tj
ET
q
81.25 243 231.75 234 re
W n
BT
10.5 0 0 10.5 81.25 284.25 Tm
(Maps)Tj
ET
81.25 268.5 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 268.5 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 264 Tm
(Adding images, page headers and)Tj
ET
q
81.25 243 231.75 234 re
W n
BT
10.5 0 0 10.5 81.25 251.25 Tm
(footers )Tj
ET
Q
BT
10.5 0 0 10.5 121.7222 251.25 Tm
(and report metadata)Tj
ET
q
328 243 216.751 234 re
W n
328 471.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 471.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
BT
10.5 0 0 10.5 337.75 467.25 Tm
(Including report parameterization)Tj
ET
Q
BT
10.5 0 0 10.5 328 454.5 Tm
(enabling filtering by users)Tj
ET
q
328 243 216.751 234 re
W n
328 438.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 438.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 434.25 Tm
(Configuring report interactivity,)Tj
-0.929 -1.214 Td
(including drill-downs, report maps )Tj
17.579 0 Td
(and)Tj
-17.579 -1.214 Td
(book marks)Tj
ET
q
328 243 216.751 234 re
W n
328 393 3 -3 re
f
0.75 w
q 1 0 0 1 328 393 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 388.5 Tm
(Linking to parameterized child reports)Tj
-0.929 -1.214 Td
(via hyperlinks or sub-reports)Tj
ET
q
328 243 216.751 234 re
W n
328 360 3 -3 re
f
0.75 w
q 1 0 0 1 328 360 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 355.5 Tm
(Creating calculated fields and custom)Tj
-0.929 -1.214 Td
(report formatting)Tj
ET
q
328 243 216.751 234 re
W n
328 327 3 -3 re
f
0.75 w
q 1 0 0 1 328 327 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 322.5 Tm
(Deploying reports to the Reporting)Tj
-0.929 -1.214 Td
(Services Web Portal)Tj
ET
q
328 243 216.751 234 re
W n
328 294 3 -3 re
f
0.75 w
q 1 0 0 1 328 294 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 289.5 Tm
(Configuring report snapshots, caches)Tj
-0.929 -1.214 Td
(and subscriptions)Tj
ET
q
328 243 216.751 234 re
W n
328 261 3 -3 re
f
0.75 w
q 1 0 0 1 328 261 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 256.5 Tm
(Securing reports and data sources)Tj
1 g
/T1_0 1 Tf
14.25 0 0 14.25 64.75 207.75 Tm
(Course Description)Tj
0 g
/TT3 1 Tf
0.143 Tw 10.5 0 0 10.5 61.75 178.5 Tm
[(This course )1.3 (introduces )1.1 (Microsoft's )1.6 (SQL )1.3 (Server )2.3 (Reporting )0.5 (Services )1.6 (2017 )1.6 (\(SSRS\) )1.3 (utility. )]TJ
0 Tw (All)Tj
0.054 Tw 0 -1.214 TD
[(reports )1.6 (are )1.9 (developed )1.4 (utilizing )]TJ
0.063 Tw 15.873 0 Td
[(SQL )1.6 (Server )2.6 (Data )2.3 (Tools \(SSDT\), )2.1 (however )1.8 (Report )1.2 (Designer )2 (is)]TJ
0 Tw -15.873 -1.214 Td
(also )Tj
0.15 Tw 2.497 0 Td
[(introduced. )1.1 (Students )1.4 (will )-1.2 (complete )0.9 (hands-on )1.4 (exercises )1.3 (creating )1.1 (a )0.9 (number )1.6 (of )]TJ
0 Tw 40.271 0 Td
(reports)Tj
0.286 Tw -42.768 -1.214 Td
[(including table-based, )1.6 (cross )1.1 (tabular )1.4 (and )1.3 (forms )1.8 (based )1.4 (designs. )0.9 (Reports )]TJ
38.359 0 Td
[(utilizing )-1 (charts,)]TJ
0.071 Tw -38.359 -1.214 Td
[(gauges, )1.1 (KPIs, spark )0.8 (lines, data )0.8 (bars )0.6 (and )]TJ
0.082 Tw 21.194 0 Td
[(tree )1.6 (maps )1.5 (will )-0.8 (be )1.1 (built. Exercises )1.1 (will )-0.8 (incorporate)]TJ
0.464 Tw -21.194 -1.214 Td
[(the )0.6 (use )0.6 (of )0.7 (report )]TJ
10.667 0 Td
[(parameters )2.3 (and )0.7 (features )2 (such )0.6 (as )0.5 (drill )-0.8 (down, interactive )0.9 (sorting,)]TJ
0 Tw -10.667 -1.214 Td
(hyperlinks, )Tj
5.88 0 Td
(book marks and report maps.)Tj
-5.88 -2.214 Td
(Consuming )Tj
0.429 Tw 6.375 0 Td
[(data )1.6 (from )2 (relational, )1.4 (multi-dimensional )0.6 (and )]TJ
0.446 Tw 24.389 0 Td
[(tabular )0.8 (data )0.7 (sources )0.8 (will )]TJ
0 Tw 14.429 0 Td
(be)Tj
0.107 Tw -45.193 -1.214 Td
[(incorporated )1.2 (into report )1.1 (designs. )0.5 (Students )1.2 (will )-1.3 (become )1.3 (familiar )0.9 (with report )]TJ
0.071 Tw 39.057 0 Td
[(deployment )0.8 (to)]TJ
0 Tw -39.057 -1.214 Td
(the new Reporting Service Web Portal )Tj
19.453 0 Td
(and learn how to use portal the management tools to)Tj
0.048 Tw -19.453 -1.214 Td
[(configure )1.8 (report )1.6 (caches, )]TJ
0.061 Tw 12.692 0 Td
[(snapshots )1 (and )0.8 (subscriptions. Instruct)0.6 (ion and )0.7 (practice )0.7 (in designing)]TJ
ET
EMC
endstream
endobj
24 0 obj
<>
endobj
25 0 obj
(l1\(uٜ;)
endobj
33 0 obj
<>/Filter/FlateDecode/Height 110/Length 35579/Name/X/Subtype/Image/Type/XObject/Width 650>>stream
HST[[5a
$#P1fEOE}怘0y憙;=g*G~>NۧO_~!B!B!B!B!B!B!B!B!B!B!B!B!B![,k'BȒb&!BȒ"B!diIBYZ8)B!,-2.!BN&C!%B!diI;XI[zv{ct3z]dzk7c"_ª`MT-H @[3\?KzkoX ?8 .3PL#RT/Gٜhz/-lEjb[7_hO
.(>c.YW/!%_pKr8OXNZ,lj'u.p݂k&R
!- I'-")2X "ca9=e'тUkE[.Z^d
]x[!k6\fK2|zU3dQ)lo%)lC7{*:iHپH YB%-
݅f<.z
(fJQ8$}d9U%D=p
/esa.8WbOOH<#qܒ o:*]k=%b#y$=@-X/ДOLOi,TB̤V SA##ŭQ
8
-^6ќic-
T;M<wFr
ks =L9{hC.U`